Using a slicer of date hierarchy to select the input on a graph

[Anonymous]

Hi,

I would like to use a slicer which includes a date hierarchy that would dynamically change the input of a graph.

If day is selected, I would like to display the data on day level, and if month or year are selected I would like to show the month aggregate sum/average. 

If month/year is selected the data would sum/aggregate on month levelIf day is selected, I would like to show data on a day level.

Thanks in advance!

[miTutorials · Accepted solution]

You can achieve this using the What If parameter from the modelling tab - For a detailed walkthrough please do check out the video below.

New Feature: Slicer to choose which columns to display on chart using Fields Parameter in PowerBI (y...

Best regards,

Ismail | MiTutorials

🎥 MiTutorials on YouTube Explore over 200+ Power BI tutorials and enhance your skills!

[Anonymous]

Now I have the problem that if i want to filter on day, that the data is aggregated at the day number level, instead of a specified month, what is the easiest way to solve this? I use multiple tables with relations.

[Anonymous]

Thank you very much!