PBI Table Visual - Expression to dynamically Hide and add columns possible ?

[Marco_Yukon]

I have a requirement to dynamically hide or add a column in a PBI table visual based on a column selection list that can be toggled on or off.

Example

Table Visual:

Col1, Col2, COl3, Measure1, Measure2

filter selection

[x ] Col1

[x] Col2

[ ] Col 3

[X] Measure 1

[ ] Measure 2

If I filter on Col 1 and Col2 as per above the table visual would change to:

Col1, Col2,  Measure1  (leaving Col3 and Measure 2 out)

Measure1 in this case would auto aggregate to the Col1 and Col2 combined aggr level.

Is this possible? 

[v-chenwuz-msft · Accepted solution]

Hi @Marco_Yukon ,

Is this you want?

If yes ,please use what if parameters. And pbix file in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.