Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to display all current filters

I can think of at least EIGHT different ways to filter data in a Power BI Desktop report, and I would not be at all surprised if there are others:

--filter pane: a specific visual

--filter pane: all visuals on a page

--filter pane: all visuals across the entire report file

--Slicers

--DAX expressions (e.g., FILTER(), ALL(), ALLFILTER(), ALLEXCEPT(), etc.)

--Visual interaction (this may not apply to my question)

--Query Folding (also may not apply)

--Drill Through page (may not apply)

MY QUESTION is whether there is a way in viewing a report to see in one place all the different filters that are affecting a visual?

I am thinking of the Style Inspector in Word, where you can see any formatting that is being used on any selected text in a document. (Styles, bolding, underlines, etc., custom formatting).  It would make some sense to reside in the More Options ellipsis on the upper right corner of a visual.

Or perhaps there is a way for Power BI to just display it on a page?  Or anywhere.  

4 Replies