Forum Discussion
Dynamic Axis changing based on Time Period and restricting data
Greeting !
I have a time period slicer which have values
Rolling 8 Weeks
Rolling 26 Weeks
Rolling 2 Quarter
Rolling 24 Months
I want to slice my all visuals in all report tabs according to the Time Period Selection and change axis for Bar Chart at the same time.
I was trying creating a disconnected table for above slicer options (4 rows) and then created dynamic measure for slicer selection. Eg If Rolling 8 weeks in Slicer then measure will calculate for 8 weeks , If Rolling 2 Queater then measure will calculate for Rolling 2 Quarter etc.
The Problem in this approach is I have at least 10 basic measures (Sales, Count, etc.. ) and all those have to rewritten 40 times for each Time Period selection from Slicer. This approach will make report slow.
So I want two things ,
1- Axis for bar chart to change from Week to Quarter to Month based on Time Period Slicer selection
2- All visuals in different report tabs should filter for that specific rolling period.
Thanks!
6 Replies
- amitchandakSuper User
bhurru , In case you need a dynamic measure slicer
For Week, refer
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
- bhurruHelper I
amitchandak Thanks for the links they are useful. I have already implement dynamic slicer selection in my case and have a different problem. Time Period slicer should change bar chart axis accordingy(Weeks, Mothns, Quarter) and also restrict time axis accordingly. If Rolling 8 weeks then only 8 weeks in Axis, If Rolling Quarter then only 2 Quarter etc..
Also woth the dynamic slicer selection approach, I need to have 40 measures as 10 base measures * 4 (Time Period values).
This would slow down the report.
Har**bleep**
- amitchandakSuper User
bhurru , You have use this https://www.youtube.com/watch?v=duMSovyosXE
Check if relative date slicer can fit in
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
- IceyCommunity Support
Hi bhurru ,
Please check if these documents could help you:
Dynamic X axis on charts – Power BI;
Dynamically switching axis on visuals with Power BI;
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.