Forum Discussion
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?
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.
1 Reply
- v-chenwuz-msftCommunity Support
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.