Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHello @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
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
103 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |