Forum Discussion

ben_w's avatar
ben_w
Frequent Visitor
8 years ago

Dynamic labels based on filter

  I have the requirement to show a dropdown box with "Yearly"; "Quarterly"; "Monthly"; "Season".   Based on this selection, graphs and tables should change their axis. I work with SSAS Tabu...
Need Help
Tips and Tricks
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi ben_w,

Could you please create some sample table for test?

Best Regards,
Angelia

ben_w's avatar
ben_w
Frequent Visitor
8 years ago

 

I made a powerbi file with the data:

https://1drv.ms/u/s!AklJKrJGWTN6iEBeeIhnM819QE5U

 

It contains a tab with 4 different graphs named 'All different possibilities'. They all share the one measure, but have a different label out of the Dim_date.

 

These 4 graphs have to be one graph with a Filter box choosing which label to apply. I made another tab woth the filter box and preset the graph on it to Month. Changing the Filter box to 'Quarterly', should update the graph to show quarters instead of months.

 

Thank you for your time and interest,

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi ben_w,

    I download your .pbix file, and I total understand your requirement. But we can't meet your needs using sclier. Because the X-axis must display column rather than measure, while the slicer can't control different columns, slicer is used to filter rows. Thanks for understanding.

    Best Regards,
    Angelia