Summary filter display in line

[user83]

hello all,

hello @amitchandak 

Please I need your help,

I try to create a line in each page of the report allowing me to summarize all the filters selected in a way that the user sees in the head of each page a summary of all the filters selected, as they are many it will not be lost or confused,  especially that I intend to hide the filters

example of a goal to be achieved (filter1,fliter2,fliter3,......) 

How can i do that ? 

thank you so much 

user83

[amitchandak · Accepted solution]

@user83 , do you want to concatenate the value and show?

Filter = "Filter 1" & concatenatex(Filter1,allselected(Filter1[Filter1]) & "Filter 2" & concatenatex(Filter2,allselected(Filter2[Filter2])

[user83]

thank you so much for your help @MFelix  @amitchandak  

[MFelix · Accepted solution]

Hi  @user83 ,

Depending on the number of filter/slicers and how they are setup you need to create a measure for example:

Active Filter =
"Date Filter: " & FORMAT ( MIN ( 'Calendar'[Date] ); "dd/mm/yyyy" ) & " to: "
    & FORMAT ( MAX ( 'Calendar'[Date] ); "dd/mm/yyyy" )
    & UNICHAR ( 10 ) & "Filter One Column: "
    & CONCATENATEX (
        ALLSELECTED ( 'Table'[FilterOneColumn] );
        'Table'[FilterOneColumn];
        ","
    )

In this case I have a date filter that is based an interval so I pick the maximum and minumum date. The Unichar is to get a line break and then I pick all the values on the FilterOneColumn that I select and I concatenat them final result is the one below:

Now you jus need to put it on a card, a table or matrix visualization and setup as you need.

[amitchandak · Accepted solution]

@user83 , do you want to concatenate the value and show?

Filter = "Filter 1" & concatenatex(Filter1,allselected(Filter1[Filter1]) & "Filter 2" & concatenatex(Filter2,allselected(Filter2[Filter2])