Slicer selection as title of my matrix header

[Sandrine]

Hello everyone,

What I am trying to do is by selecting a slicer, it appears on my matrix header.

In this case, on the matrix on the right, Baseline 1 should be named Current, Baseline 2 should be PFR 2022 Final and Baseline 3 Test.

The slicers are created with this calculated table:

So each slicer is independant (there is Slicer_Baseline_1,Slicer_Baseline_2 and Slicer_Baseline_3) and each of these slicer have an id and the label. But they are not connected to the rest of the tables.

This is what is displayed on the matrix as Baseline 1 when I selected something on the slicer Baseline_1. It calculates the value of the working days.

I also need to calculate a delta that substract my Baseline 1 - Baseline 2, and I want this column to appear only once for each year:

Can anyone please help me to display my slicer selection as my matrix I would be very greatful.

Thank you. 

Please let me know if you need further information.

[MFelix]

Hi @Sandrine ,

When you refer that you want to have the dinamic title what does it means? Do you want to select the columns to appear?

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[Sandrine]

Hello @MFelix ,

It means that for example for Baseline 1 when I select Current, I want it to appear on the Asset line instead of Baseline 1 apparearing :

like this :

Kind regards

Sandrine

[MFelix · Accepted solution]

Have you tried using the Field Parameters for your 3 slicer options?

This allows you to select what values appear in the charts they can be used with measures or columns and you can make the names has you need.

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters