Forum Discussion
Create table with columns that can be selected by users
Hello,
I have a table filled with text information which has about 20 columns. Is there a way that users can dynamically select the column in the table that they want anytime without editing the report?
let's say we have a table with columns A to T and one user wants that the table only shows columns B, E, F and another one wants to see column S only etc. Appreciate your help.
This video demonstrates a technique to select the desired column(s) to display. The concept is to create a slicer based on the column that is used in the matrix columns.
https://www.youtube.com/watch?v=6jeSIRpjv0M
If this is not what you're looking for, please provide sample data and the desired output.
3 Replies
- DataInsights
Super User
This video demonstrates a technique to select the desired column(s) to display. The concept is to create a slicer based on the column that is used in the matrix columns.
https://www.youtube.com/watch?v=6jeSIRpjv0M
If this is not what you're looking for, please provide sample data and the desired output.
this is exactly what I was looking for 🙂 thank you DataInsights !
Hi catsy,
You can do unpivot columns on your table value fields to convert them to attribute and values, then you can use filter to control which files displayed:
In addition, you can also take a look at the following link about dynamic attribute filter:
Dynamic Attributes In A Power BI Report
Regards,
Xiaoxin Sheng
