Using a Slicer to choose date groupings (group by day, week, month, year etc)?

[Anonymous]

Hey all, Apologies if this has been asked before (I can't seem to find a solution). I'm trying to use a slicer to give the user the ability to select whether the x-axis (date) of a line chart is day/week/moth/year. I understand that this is possible with drill through and a date hierarchy however I'm wanting to have the ability to select this date view type and have it affect all visualizations on the page (I don't believe you can have drill through sync with various visuals). My dataset has columns for each of the groups I require however I cannot find a way to dynamically set these columns for the axis. Has any one found a way around this?

[v-shex-msft · Accepted solution]

Hi @Anonymous,

I think following links will suitable for your requirement, please take a look on them if it helps:

Dynamic Category Using a Slicer

Dynamic Attributes In A Power BI Report

If above not suitable for your requirement, please share some sample data and expected result.

Regards,
Xiaoxin Sheng

[Anonymous]

Amazing!

Thanks for this, it has solved my problem (and a few other things I've been having issues with!)