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

 

avatorl's avatar
avatorl
Icon for Impactful Individual rankImpactful Individual
6 years ago

First column should be a column. Not measure.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

    Use BLANK() instead of "" in your measures.