Forum Discussion
Hide and Show based on Slicer selection
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
Impactful IndividualCover 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.
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
- avatorl
First column should be a column. Not measure.
Hi avatorl ,
If i keep first column as column (not measuer) then i am not getting the expected output. You can see from the below screenshot that if i select ID as 1 from table 1 in the drop down and in the grid we are getting ID 1 as well as ID 3 not sure why this is happening...
Thanks
Prakash
- avatorl
Use BLANK() instead of "" in your measures.