Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Dashboard Filter by

(1) ShareShare
ReportReport
Posted on by 25

Hi, I have a question on filtering dashboard. I want to create a new dashboard and I want to add some other field inside the Filter by category and right now I haven't found a way to do it:

3288.pastedimage1626240458652v2.png

I want it to be like below example,where I can select the filtration not just based on Created on and Modified on:

1106.pastedimage1626240327619v1.png

How do I do that? 

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dashboard Filter by

    Hi Nur_Nina,

    By custom time frame do you mean the one shown in the screenshot below?

    4405.pastedimage1626311662311v1.png

    As I mentioned before, the default time frame filter value for the Filter By field.

    Change time frame of the rows displayed. You can choose from predefined timeframes or select your own.

    In custom time frame, Start Date and End Date fields are not fields of current entity, they are just time selectors fixed to the time frame of dashboard design, which just allow you to choose any time you want to filter current dashboard.

    3857.pastedimage1626312200670v2.png

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • Nur_Nina Profile Picture
    Nur_Nina 25 on at
    RE: Dashboard Filter by

    Hi ,

    thanks for replying. I've noticed that inside the dashboard,there is also a custom time frame which has Start Date and End Date. What are these dates refer to? because I don't see any Start Date or End Date field inside the entity.

    [quote user="Leah Ju"]

    Hi Nur_Nina,

    Users can apply additional filtering with global filter and timeframe filter.

    1.For timeframe filter:

    When the dashboard form opens, at the top of form:

    • Filter By: The field that the time frame filter applies to.

    • Time Frame: The default time frame filter value for the Filter By field.

    Through my test, if you want to one field can appear in the drop-down list of the 'Filter By', you need ensure that the field is date data type or rollup field type.

    6622.pastedimage1626244588581v4.png 4530.pastedimage1626245779990v2.png

    2337.pastedimage1626245673717v1.png

    2.For global filter:

    For a field to appear in the global filter, you have to set the Appears in global filter in interactive experience flag for this field. 

    0511.pastedimage1626244486710v3.png

    you can refer following link for more details:

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/configure-interactive-experience-dashboards?view=op-9-1#configure-fields 

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

    [/quote]
  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dashboard Filter by

    Hi Nur_Nina,

    Users can apply additional filtering with global filter and timeframe filter.

    1.For timeframe filter:

    When the dashboard form opens, at the top of form:

    • Filter By: The field that the time frame filter applies to.

    • Time Frame: The default time frame filter value for the Filter By field.

    Through my test, if you want to one field can appear in the drop-down list of the 'Filter By', you need ensure that the field is date data type or rollup field type.

    8204.pastedimage1626244588581v4.png 5468.pastedimage1626245779990v2.png

    3632.pastedimage1626245673717v1.png

    2.For global filter:

    For a field to appear in the global filter, you have to set the Appears in global filter in interactive experience flag for this field. 

    5633.pastedimage1626244486710v3.png

    you can refer following link for more details:

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/configure-interactive-experience-dashboards?view=op-9-1#configure-fields 

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans