Create a card that will show me all selected values in the slicers on the report

[arnold61]

Hi Community,

I am trying to create a card that will show me all selected values in the slicers on the report. The reason why I need it is that the slicers themselves are hidden using a bookmark and when users want to print the report they would like to see which filters have been applied. Unhiding the slicers is not an option because it will cover some visuals.

I have no issue with creating the measure for simple slicers like date, country, etc. However, I have a hierarchy slicer like the below and that is what I am struggling with at the moment:

In the example above my measure should return this:

A: DE,EN ; B:1

I have tried making use of CONCATENATEX function, but that does not work as I want it to work, unfortunately. Maybe some of you have any ideas?

[arnold61]

Thanks for the suggested solution, however, the issue is that we can have a lot of categories, not just A and B and we do not have a fixed number of those categories, moreover they can change over time and we need the DAX formula to pick that up automatically...do you have any ideas?

[ryan_mayu]

@arnold61 

so far i don't have any better solution for this. Let's see if anyone else can help you

[ryan_mayu]

@arnold61 

here is a workaround for you.

Measure = 
VAR _counta=COUNTROWS(FILTER('Table (2)','Table (2)'[group]="A"))
VAR _countb=COUNTROWS(FILTER('Table (2)','Table (2)'[group]="B"))
return IF(ISBLANK(_counta),"B:" & CONCATENATEX('Table (2)','Table (2)'[value],","),if(ISBLANK(_countb),"A:" & CONCATENATEX('Table (2)','Table (2)'[value],","),"A:"&  CONCATENATEX(FILTER('Table (2)','Table (2)'[group]="A"),'Table (2)'[value],",") & ";B:" &CONCATENATEX(FILTER('Table (2)','Table (2)'[group]="B"),'Table (2)'[value],",") ))

pls see the attachment below