Forum Discussion
Show multiple slicer selection as dynamic text
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
Below formula works
Title =
"US > DAIRY> "
& (CONCATENATEX (
VALUES ( 'Dairy'[Dairy] ),
'Dairy'[Dairy])
&
" >"
&
CONCATENATEX (
VALUES ( 'Dairy'[Milk] ),
'Dairy'[Milk],
", "
))
5 Replies
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
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],))dokat ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Below formula works
Title =
"US > DAIRY> "
& (CONCATENATEX (
VALUES ( 'Dairy'[Dairy] ),
'Dairy'[Dairy])
&
" >"
&
CONCATENATEX (
VALUES ( 'Dairy'[Milk] ),
'Dairy'[Milk],
", "
))
