A problem a day keep the doctor away!!

[AgoZ_KH]

Hi to all community!! Have a nice day!

today my problem is: how to show in a pBI report table a colum or another when is filtered a value or another

Suppose you have a year week filter active on a report page like this (with radio button check):

o 32

o33

o34

o35

and so on

Suppose you have imported an Excel table like this:

UserID   | City         | Number    | Value 1  | Value 2   | Value 3 | ...

001        Rome        01234567    18%        107%        67%         ...

I want that when filter is checked on a value the pBI report table shown is:

o 32 (is checked)

UserID   | City         | Number    | Value 1  

001        Rome        01234567    18%        

or

o 33 (is checked)

UserID   | City         | Number    | Value 2  

001        Rome        01234567    107%   

or

o 34 (is checked)

UserID   | City         | Number    | Value 3 | 

001        Rome        01234567    67%         

and so on

I try with conditional statment or DAX VAR but I didn't find the right way ...

Can someone help me in finding the right solution?

Thanks in advance

Ago

[v-kelly-msft]

Hi  @AgoZ_KH ,

How to ensure that whether Oxx is checked?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[AllisonKennedy]

@AgoZ_KH
I think an UNPIVOT would help you here. You will need to unpivot the Value 1, Value 2, Value 3 columns. Then might need to add an Index column if they aren't named to match the Week of Year column in your date table.

Ultimately you want your Excel table to look like:
UserID | City | Number | Week | Value

001 Rome 01234567 1 18%

001 Rome 01234567 2 107%

001 Rome 01234567 3 67%

...

So to unpivot the columns, click Home tab > Transform Data > Preferably I would rename the Value columns to Week number, then select the Value 1 - Value ... columns. Click Transform tab in Power Query > Unpivot Only Selected Columns. Home tab > Close and Apply.

Then you can relate your Excel table week number to date table week number.