Forum Discussion
Catrice
Advocate I
6 years agohide/unhide columns in Report Table depending on filter
Hello everybody,
As a relative newcomer to Power BI, I have a question about the dynamic visualization of a report table. Depending on a filter, I want to show columns in this report table that are relevant or hide columns that are not relevant. I think this is a typical use case, but I still don't have the experience of whether I can solve this with 'Measures' or 'Hierarchies' or 'Groups' or ....
Thanks for startup hint.
6 Replies
- parry2k
Super User
Catrice Welcome to the club. Please read this post to get your answer quickly. IN nutshell, share some data and expected output, and it helps to answer the question quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- Greg_Deckler
Community Champion
So in general you cannot dynamically show or hide columns in a table visualization. You might be able to get there doing something tricky but not sure what that would be. Perhaps a variation of https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/td-p/963588