Forum Discussion

Marco_Yukon's avatar
Marco_Yukon
New Member
4 years ago
Solved

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

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?