Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filters on this Visual - Not Working / Stopped Working

I often use the visual level filters to hide various content until something is selected.  This article walks a user through many of the steps I've taken to accomplish this: https://exceleratorbi.co...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Yes, they are properly treating those measures are Boolean.  The measures are working as expected, as proven by the cards that display their values.  

     

    This discussion is the only place that I can find that confirms that there is a limitation:

    https://community.powerbi.com/t5/Desktop/I-can-t-change-filter-in-Visual-level-filters/m-p/1002462#M475773

     

    That said, I have copied, deleted, started over, and am using the exact same measures in multiple pbix files and it seems that the limitation is that it only works when a multi-row card is showing a categorical list of values.  

     

    Here it is working:

     

    As soon as I change the displayed field to a measure or a numeric value, it stops working:

     

     

    I found a workaround that provides the necessary results:  Make a multi-row card with a categorical list of values, put in place the visual level filter, then change the card to display the measure.  The visual level filter stays in place, and even though it cannot be changed at this point, it still works.