Forum Discussion
SLICER to choose column
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?:)
- Anonymous4 years ago
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
2 Replies
- AnonymousNot applicable
Unpivot the data then filter on the column containing the column names.
- AnonymousNot applicable
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