web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Having multiple filters on a chart

(0) ShareShare
ReportReport
Posted on by

Hi there -

I am trying to filter the chart below to filter by a custom date range as well as filter by the account (or customers). Any ideas on how this can get done? Ideally I would be able to filter by a date range, once I have the results I could filter down to the account. 

1462.Accounts.PNG

*This post is locked for comments

I have the same question (0)
  • Verified answer
    LuHao Profile Picture
    40,892 on at

    Hi partner,

    Since the data for the chart is completely from the view, you only need to filter the view and the chart will automatically apply the same filter.

    In the Won Opportunities view, click on the filter icon to the right of the Customer field and Time field to filter them.

    1258.5.PNG    2476.2.PNG

    Once the view is filtered, its chart is also filtered.

    2476.3.PNG

    If you don't want to filter the view, then I recommend you create a new view which has been filterd.

    Click the Create View button on the command bar. Select Use Saved View as Won Opportunities, add filters of customers and time on top of it. Click Save As to save as another view.

    1258.5.PNG    4863.4.PNG

    The chart for this view is the filtered chart.

  • Community Member Profile Picture
    on at

    Got it! This was very helpful! Thanks so much Lu.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans