Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

formating based on only single value selected in slicer

Hi helpfull community,

 

in my report I have a graph that by default plots data for all points in the data base but is useless as such (by design).

It becomes usefull if a certain slicer has been used to filter down to a single value.

 

My idea now is to hide the plot in all cases that more than one value has been slected in the slicer.

This could probably be done by an overlay that becomes transparent when only a single value for the slicer is slected?

But how? Or are there other ideas?

 

Thanks,

Torge

  • Just blank your measure when there is more than one value selected...

     

    IF(HASONEVALUE(yourslicer[column]), measure, BLANK())

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks lukiz84, this has inspired me to find a solution 🙂

  • lukiz84's avatar
    lukiz84
    Icon for Memorable Member rankMemorable Member

    Just blank your measure when there is more than one value selected...

     

    IF(HASONEVALUE(yourslicer[column]), measure, BLANK())