Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Suggested answer

How to make chart dynamic based on table of information?

Posted on by 5

I'm brand new to google sheets. But how would I make a chart dynamic to this table here? I want to include a dropdown menu that has stuff like: " Last Year","Last 6 Months" and then filter it by category. I was thinking of maybe using =filter(), but wanted to get some input

I tried using =filter(), using a pivot table, but I'm just lost.

Categories:
  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: How to make chart dynamic based on table of information?

    Hi olansgz,

    Are you using the dynamics365 app?

    If so, you can't include a dropdown menu to the chart directly, but you can add more views with different filters.

    For date field, you can have the following filter to select as your needs:

    pastedimage1671689740162v1.png

    The chart is shown based on current view, so you can select the view you need, then click show chart button:

    pastedimage1671689966848v2.png

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans