Forum Discussion

bhurru's avatar
bhurru
Helper I
6 years ago

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