Show multiple slicer selection as dynamic text

[dokat]

Hi,

I'd like to show slicer selections on the report as dynamic text like below. Is this possible to do in Power BI? I have slicer name, Dairy, Milk, Skim. Appreciate any help

US > Dairy > Milk > Skim

[dokat · Accepted solution]

Below formula works

Title =
"US > DAIRY> "
& (CONCATENATEX (
VALUES ( 'Dairy'[Dairy] ),
'Dairy'[Dairy])
&
" >"
&

CONCATENATEX (
VALUES ( 'Dairy'[Milk] ),
'Dairy'[Milk],
", "

))

[amitchandak]

@dokat , On why is drag them in one slicer and create Hierarchical slicer.

Second use bookmarks. Show hide.

Thrid is - unpivot all these columns and you will get these names in rows. Then create two slicers one with a column name, another with values

https://radacad.com/pivot-and-unpivot-with-power-bi

[dokat]

I tried below formula it works for the first slicer(Dairy) and doesnt show the value in second slicer(Milk) and anytime it is not selected it shows all the values. I want it to show only values when slicer is selected.

Title =

"US > STATIONERY > "

& CONCATENATEX (

VALUES ( 'Dairy'[Dairy] ),

'Dairy'[Milk],

", ",

CONCATENATEX (

VALUES ( 'Dairy'[Dairy] ),

'Dairy'[Milk],

))

[amitchandak]

@dokat ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[dokat]

@amitchandak   Ultimately I want outcome to look like below.

US > Dairy > Milk        Dairy and Milk Slicer Selection

or

US > Dairy                    Dairy Slice Selection

or US                             No Slicer Slection

I tried below formula it works for the most part however still shows ">" when no slicer is selected and i'd like it to show blank when no slicer is selected

Title = "US > Dairy> "
&
SELECTEDVALUE('Dairy'[Dairy],"")
&
" >"
&

SELECTEDVALUE('Dairy'[Milk],"")