Data Formatting and Parameterized report

[SwaroopRoyM]

Hi,

I have a filter (both page level/report level) in my report (pbix). my requirement is to display data in visuals based on the selection made. The issue here is i've to get the data from separate tables based on the selection made.

For example: in my Filter i've 2 values t1, t2. If i select t1, then the data should be from table1, if t2 then the data should be from table2.

Is this possible in Power BI? If yes, how to achieve this?

Thanks,

Swaroop

[Michiel]

If you have filter values t1 and t2, you'll have a table in your model that contains these values. When you add a column to this table with a number value (I always use powers of 2 for this, so in this case 1 and 2), it is possible to detect the value selected by evaluating the sum of the number value, e.g. SUM(Selection[Code]).

Taking data from one or the other table is a matter of creating multiple measures, e.g.

Result1 = SUM(Table1[Value])

Result2 = SUM(Table2[Value])

The measure to be used in the report can select on of these using SWITCH:

Result = SWITCH(SUM(Selection[Code]), 1, [Result1], 2, [Result2])