Forum Discussion

daniellamoore29's avatar
daniellamoore29
Helper I
2 years ago
Solved

Hide visual base on slicer selection

I have a gauge visual, and I'm trying to hide the visual based on the slicer selection. 

I have three measures which all work: 

 

Measure 1:

Check filtered = ISFILTERED(Query1[% Metric Name]) -- Returns true when any selection is made

 

Measure 2:

Message = IF([Check filtered], "", "You must first select an indicator name from the slicer to see the results")
 
Measure 3:
Hide visual = IF([Check filtered], 1, 0)
 
When adding the Hide Visual measure to the visual filters, it does not let me change the items from is less than to is

 

what can I do to resolve this please?

 

 
General Comment
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi daniellamoore29 
    If you can put these filtering conditions directly to the measures of your gauge.
    Something like :

    Test metric = if(ISFILTERED('Table'[Metric Name]),sum('Table'[Metric Value]),"")
     

    You can download the pbix from This link 

     

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

     

3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    Hi daniellamoore29 
    If you can put these filtering conditions directly to the measures of your gauge.
    Something like :

    Test metric = if(ISFILTERED('Table'[Metric Name]),sum('Table'[Metric Value]),"")
     

    You can download the pbix from This link 

     

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

     
    • Ritaf1983's avatar
      Ritaf1983
      Super User
      2 years ago

      daniellamoore29  
      I must admit that I don't know 🙂
      I work only with white backgrounds all others are not efficient for effective data visualization.
      For example, our brain needs to work hard to read white on blue...