cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Ant_jesus Frequent Visitor
Frequent Visitor

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

Hi @Ant_jesus,

 

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
2 REPLIES 2
Community Support Team
Community Support Team

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

Hi @Ant_jesus,

 

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Ant_jesus Frequent Visitor
Frequent Visitor

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

Amazing!

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