Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Hide data if visual interactions result in client count below a set threshold

Hello - I have a Power bI desktop page that has multiple visuals and cards displaying various cuts of my data file.  I have interactions turned on to allow filtering of all other visuals on the page when columns in the columns charts are selected.  I would like to hide data in all visuals whenever the client count (metrics always displayed in the visuals) drops below five given compliance reasons.  I would like all other columns to remain, but the columns with less than five should hide or say "Less than 5 clients".  

 

I have checked other forum posts, but can not find the exact answer I am looking for.  I do not want to only make the bar transparent as the tooltip would still appear when hovered over.

 

I am not able to post a sample data cut, but every transaction has one row in the data and the visuals are showing high level views by client industries, products purchased, etc.  

 

Thank You!

  • Hi Anonymous ,

     

    You can create a measure and add the measure to the 'Filters on this visual' pane.

    All visuals wishing to hide data must add this measure to the filter pane.

    Filter = 
    IF(
        COUNT(Table[client]) < 5,
        1, 0
    )

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    You can create a measure and add the measure to the 'Filters on this visual' pane.

    All visuals wishing to hide data must add this measure to the filter pane.

    Filter = 
    IF(
        COUNT(Table[client]) < 5,
        1, 0
    )

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.