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,

Calculated column are initialized regardless of Slicers. And for your requirement, the column name will be changed by slicer. Based on my under standing, the column name must come from one field of your resource table, right? The measure can changed as the slicer. Column can not change as the slicer.

Best Regards,
Angelia

  • ben_w's avatar
    ben_w
    Frequent Visitor
    8 years ago

    I don't find a way to accomplish to use a measure as a dimension (and thus causing other measures to calculate based on it); do you have more information about this?

    • 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,