Forum Discussion

Deedubpee's avatar
Deedubpee
Regular Visitor
3 years ago

Hiding Columns in Tables that don't have Data

I am trying to figure out how to only show columns that have data associated with it. In this case below, I have a filter on the page where you can pick the "Asset", and then under "Ownership", it will then show you the percentage of ownership by company. I only want to show the companies that own a % of the asset and want to hide the columns that have 0% ownership (highlighted in yellow). Any tips on how to do this?

 

 

 

1 Reply

  • giammariam's avatar
    giammariam
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hey Deedubpee, I imagine that this could be done if you flatten that portion of your data and switch to the matrix value. If you can provide a sample sanitized .pbix file (here's how), I can try to help.