SLICER to choose column

[Agnes_PB]

Hi, 

I would like to create slicer where user can choose column.

e.g. I have the columns: number of IT user, number of clients and so on.

The user can choose in slicer column "number od IT user" and in dashboard he get data from this column.

I tried to use case e.g CASE  when "number of IT user" then number of IT user.

Unfortunately it doesn't work.

Have you got any idea?:)

[Anonymous · Accepted solution]

Hi @Agnes_PB,

You can take a look at the following blog to do the 'unpivot column' on these fields and refers to the blog operation to create a dynamic attribute report:

Dynamic Attributes In A Power BI Report - P3 Adaptive

Regards,

Xiaoxin Sheng

[Anonymous]

Unpivot the data then filter on the column containing the column names.