Group by day, week, month with slicer in Power BI

[Anonymous]

My report will display the data of everyday and i would like to make a slicer like this so that i can see the data monthly, daily, weekly,...

[v-cgao-msft · Accepted solution]

Hi @Anonymous ,

You can use the field parameters to switch the axis.

Please refer:

Let report readers use field parameters to change visuals

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous]

hi, thanks for your support but did you encounter the problem such as when group by week the total may be higher than usual 

[keshavagrawal27]

Hi @Anonymous ,

You can create a date hierarchy and then use that date hierarchy in the slicer. It will give you the desired result.

If this helps you then please mark it as a solution and hit the thumbs up. Thanks.

[Anonymous]

But when i added date hierarchy in my slicer, it would show the date value (f.e: "8/23/2022") instead of "month", "day", "week"

[keshavagrawal27]

Therefore you will need to create a custom date hierarchy by defining a relationship  between month, day and week columns