Forum Discussion
Hide and Show based on Slicer selection
Impactful IndividualThen the only way for you - use measures that return empty string (for a card) or blank() (for a table) and conditional formatting to hide all visible elements of a card / table. You don't need write a measure like the above with one row of DAX per each ID, you can use a column in your table.
A measure should return you either visible value or empty string. And you'll need some measures for conditional formatting to hide elements like Category in a card by changing font color to background color.
Impactful IndividualExample:
will return an ID if selected an id with Status = 'Yes' or empty string if Status = 'No'
Hi avatorl ,
Yes it is working fine but how to hide column headers in Tables when the status is "No"?
I dont want to show the entire table if the status is No. I can able to hide the values with your suggession but i couldn't able to hide column names.
Thanks
Prakash
- avatorl
Probably the only way is to put a card in front of a column header (just hide the header behind a card). And then you can control font color via conditional formatting based on a new measure.
Hi avatorl ,
If i select ID no. in slicer which has status as "No" then the values are getting hided but the column headers are still showing.
I want this column header too to get hided. Could you please let me know that whether is that possible?
Thanks,
Prakash
- avatorl
Cover your table (or just columns you wnat to hide) with a card.
Card value measure:
Blank := ""
Card background conditional formatting measure:
Background := IF( <your rule is here>, "#FFF0","#FFF" )
If TRUE then transparent color (what is behind the card is visible), if false then white color (what is behind the card is hidden)
See this topic https://community.powerbi.com/t5/Power-Query/write-unique-password-to-see-the-data-of-that-partucal-person/m-p/1154949#M37667. It should be usefull.