Forum Discussion
Hide show columns dynamically in TABLE
Super UserNot really, apart from BLANK()ing out the extra two columns via a measure, or using measures as columns.
can the headers also be made hidden dynamically using measures along with values,if yes ,can you provide some examples.
- lbendlin
no, all you can do is print the headers as white text on white background (via conditional formatting). You can't make them disappear.
v-xuding-msftCommunity Support
Hi ganeshharan81 ,
For Table visual, we can't make columns hided dynamically with DAX. It can be implemented in Matrix. (Reference: https://www.youtube.com/watch?v=6jeSIRpjv0M)
I think you could create two Table visuals and use bookmarks to make them shown or hided. For more information, please reference the blog and the video:
https://powerbi.tips/2019/08/dynamic-visuals-using-buttons/
https://www.youtube.com/watch?v=_Afcj8mT5_Q
- v-xuding-msft
Hi ganeshharan81 ,
Does it make sense? If yes, please accept the helpful answer as a solution. More people who have the same request will benefit from this thread.