hide/unhide columns in Report Table depending on f...

Catrice · ‎04-15-2020

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.

Greg_Deckler · ‎04-15-2020

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...

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

parry2k · ‎04-15-2020

@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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Catrice · ‎04-15-2020

I'm sorry if my questions get stupid:): Where can I upload a file in the forum? I just created a pbix example and wanted to upload it.

parry2k · ‎04-15-2020

@Catrice you should share using onedrive/google drive link.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.