Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Edit filter greyed out

I am trying to have make a textbox/card/whatever I can get working disappear when nothing is selected in a slicer. So far I created a measure "IsCategoryFiltered" which checks if the desired category is checked or not. I have verified this works by putting "IsCategoryFiltered" in a table and checking and unchecking the slicer. 

 

When I go to my card and put "IsCategoryFiltered" into the filter section, I am unable to edit it in any way. Why is this? Does anyone have a workaround?

IsCategoryFiltered and the greyed out menu are shown below:

 

Thanks in advance

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    Do you mean using the IsCategoryFiltered measure as a card visual object and then filtering on IsCategoryFiltered? Your card visual object will display a value that is determined by whether the filter column is checked or not, i.e. 0 and 1 appear, so placing that filter on the card visual object is not supported. You can place the measure on the filter pane of a matrix or table visual.

     

     

    If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

     

    Best Regards,

    Neeko Tang

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