I have a very extensive report with a lot of slicers.
What I need is something that shows me the filters applied (or slicers) at the moment. It dynamically should change when a slicer is (des)selected.
Since Power BI does not offer this feature, I need a workaround.
What I achieved:
In another smaller report, I created one measure for each column that returns a text if the column ISFILTERED:
M_checkfilter = IF(ISFILTERED(Table[Column]);"Filter is Active";"")
This measure is used within a text box card visual and situated above a slicer that filters the previous column referenced. Then, when the slicer is actived, the text appears (color: red, font size: medium-high) so the user can easily show what filters are actived.
Well, it works, but in an extensive report it comes unmanageable creating one measure and text box for each column. I'm looking for something more centralized.
After test, the measure and column are not supported in text box, you can create a card visual to display the measure. You can review the following feature request and vote it, you also create an idea here.
@javi0unavailabl Thanks a lot for the fast response and sorry for the dealy but i was out of office.
I did tried hundreds of changes before i post this, your sentence "should" do exactly what i am looking for but it does not work, it seems to appears and error with & I have tried, just with MIN, or with MAX, with less text, with more parenthesis and hundreds of combinations, but it does not work, i am out of ideas. If you have any i would love to hear them.