Forum Discussion

ScottG's avatar
ScottG
Icon for Advocate II rankAdvocate II
10 years ago
Solved

How can I switch the measure a chart or table is using based on a slicer choice?

Good Day,   We are creating a Power BI report where the data source is a live SSAS Tabular Cube.   We would like to create a number of pages within the report where the report user can switch whi...
  • asocorro's avatar
    asocorro
    10 years ago

    If you mean something like this:

     

     

    Then it's all in the data model.  These are the (simplified) two main tables supporting the report above:

     

     

    In our case, we have three similar but separate pages (and three corresponding measure tables), because the measures have different data types (percentage, currency, and whole number).

ScottG's avatar
ScottG
Icon for Advocate II rankAdvocate II
10 years ago

Thank you for the suggestion I will attemp this later tonight.

 

So in this case the Measure and Measure Rates tables become a dimensions?

 

Is there any DAX required for this approach? Sorry quite new to DAX (done lots of MDX)...

 

Is there no way to put all the measures (different formats) in one slicer so that format is drawn from the actual measure's formatting in the SSAS Cube?