Create table with columns that can be selected by users

[catsy]

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.

[v-shex-msft]

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:

Unpivot columns (Power Query) 

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

[DataInsights · Accepted solution]

@catsy,

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.

[catsy]

this is exactly what I was looking for 🙂 thank you @DataInsights !