Text box to show selected filters

[Anonymous]

Hello,

I'm trying to make a textbox that dynamically changes based on these slicers:

I'd like it to say something like: 
"Development in ("Enhet Slicer") for ("Nøkkeltall Slicer"), ("Type slicer") in ("Kunde slicer") for ("Brand slicer")"
For Type, Brand and Kunde, i'd like it to say "all" when all options are picked and each option picked if all options aren't picked. 
The enhet and nøkkeltall slicers are single-choise. 

Please let me know if more information is needed. Hope it wasn't too difficult to understand. 

[Anonymous]

 Hi @Anonymous ,

The text box is a static result. If you want a dynamic result, you can use Card visual.

You can also create a measure to add fixed text.

Measure = SELECTEDVALUE('Table'[Slicer value])&" text123"

Add the measure to the card visual.

Measure = SELECTEDVALUE('Table'[Slicer value])&" text123 "&SELECTEDVALUE('Table (2)'[ Slicer value2])

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi there,

Apologies for the interference but I would like to have exactly that result but without using a slicer. Is it possible to have the filter applied on another visual to influence my selectedvalue()? 

Thank you for your help,

Sam

 

[Anonymous]

Hello, this doesn't work with multiple option slicers. When I pick more than one option it turns blank in the text box. 

[Greg_Deckler]

@Anonymous I did something like this once: The Most Amazing, Mind Blowing Dynamic Slicer Titl... - Microsoft Power BI Community

[Anonymous]

Hello again, @Greg_Deckler. I've managed to use your DAX and it works for one of my slicers. However, I would like my text to be a combination of the slicers. Any idea how I can do that?

[Anonymous]

Hello @Greg_Deckler. I appreciate your effort. However, for a newbie PowerBI user, this is not very intuitive. 

[Greg_Deckler]

@Anonymous How about a simple version to start with:

Measure =
  "Development in " & MAX('Enhet'[Column) & " for " & MAX("Nøkkeltall'[Column]) & ", " & MAX('Type'[Column]) & " in " MAX('Kunde'[Column]) & " for " & MAX('Brand'[Column])

More Complex Version =
  VAR __Enhet = IF(COUNTROWS('Enhet') = COUNTROWS(ALL('Enhet')),"All",MAX('Enhet'[Column]))
RETURN
  "Development in " & __Enhet & " for " & MAX("Nøkkeltall'[Column]) & ", " & MAX('Type'[Column]) & " in " MAX('Kunde'[Column]) & " for " & MAX('Brand'[Column])

Note, I have no idea what your actual table and column names are.

[Anonymous]

My columns are 
Enhet (unit) - Can be either show a value or a volume
Nøkkeltall - Key measures. YTD, MAT etc, single choice.
Brand - Can be multiple choice. 
Kunde - List of customers. Can be multiple choice.
Type - Shows the type of product. Large, small, etc. Can be multiple choice. 

My table is called "Sheet1"

@Greg_Deckler