cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mikerossanthony Frequent Visitor
Frequent Visitor

Active Filters Pane Issues

Okay so lets say I have the following dataset: 

 Capture 019.PNG

 

 

 

 

 

 

Then I create a bookmarks for a user that filters to Company A, B, and C and Filters to only show Action Required. In this example only Company B has any TXs in Action Required:

 

Capture 020.PNG

 

 

 

 

I want an "Active filters" pane so users can see which filters are set, especially when using bookmarks that were setup by other users, so I created the following Measure:

 

Active Filters - TX Table = 
var line_break = unichar(10) & unichar(10) return
unichar(10)
& if(not(ISFILTERED(TX[Company]))&& not(ISFILTERED(TX[Status])), "All",

IF(NOT(ISFILTERED(TX[Company])),"",
"Company:"
& UNICHAR(10) & "• "
& CONCATENATEX(
ALLSELECTED(TX[Company] ),
TX[Company],
unichar(10) & "• ")
& line_break)

& IF(NOT(ISFILTERED(TX[Status])),"",
"Status:"
& UNICHAR(10) & "• "
& CONCATENATEX(
ALLSELECTED(TX[Status]),
TX[Status],
unichar(10) & "• ")
& line_break)
)

 

However, because of the cross-filtering when using ALLSELECTED() I will be missing items from the active filters pane if they do not have any data, so in this case Company A and C are missing from the active filters pane and i want them there:

 

Capture 16.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I tried using parent tables instead for the report filters, and had my active filters measure point to those tables:

 

Capture 018.PNG

 

 

 

 

 

 

 

 

 

Active Filters - Parent Tables =
var line_break = unichar(10) & unichar(10) return
unichar(10)
& if(not(ISFILTERED(Company[Company]))&& not(ISFILTERED('Status'[Status])), "All",

IF(NOT(ISFILTERED(Company[Company])),"",
"Company:"
& UNICHAR(10) & "• "
& CONCATENATEX(
ALLSELECTED(Company[Company] ),
Company[Company],
unichar(10) & "• ")
& line_break)

& IF(NOT(ISFILTERED('Status'[Status])),"",
"Status:"
& UNICHAR(10) & "• "
& CONCATENATEX(
ALLSELECTED('Status'[Status]),
'Status'[Status],
unichar(10) & "• ")
& line_break)
)

 

This makes the active filters pane behave as I'd like however since Report filter pane is looking at the parent table, every value is 1 which I don't think I can live with:

 

 

Capture 017 - Copy.PNG 

 

 

 

 

 

 

 

 

 

 

 

 

Is there anyway to achieve what I'm after, either by changing the active filters measure or somehow manipulating the behavior or report filters?