Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hide and Show based on Slicer selection

Hi All,   Based on slicer selection my card should get hid and show. In below eg. If i select ID = 1 then my card will display "Yes" in the status and card should be visible. If i select ID = 2 the...
Need Help
avatorl's avatar
avatorl
Icon for Impactful Individual rankImpactful Individual
6 years ago

Example:

Measure := IF (
SELECTEDVALUE('Table'[Status]) = "Yes",
SELECTEDVALUE('Table'[ID]),
""
)

will return an ID if selected an id with Status = 'Yes' or empty string if Status = 'No'
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    avatorl
    Icon for Impactful Individual rankImpactful Individual
    6 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      avatorl
      Icon for Impactful Individual rankImpactful Individual
      6 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi avatorl ,

         

        Yes It is working absolutely fine.

        But i have 1 issue is there especially in one to many scenario.

        In Table 1 for ID one i have 1 row. In Table 2 for ID one let us imagine i have 2 rows as shown in below example.

         

         

        when i select ID (Table1) from dropdown then the expected output which i am looking for is:

         

        But since i have created all the four fields as measure on selecting ID 1 in slicer i am getting:

         

        Since it is present in measure i am not getting the expected output. Apart from this it is working fine for everything. It is not working for one to many scenarios.

        Could we get the expected output?

         

        Thanks in Advance