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.
Hi, I searched the forum but didn´t find my question already asked so far.
I am using financial data and created a slicer that let´s the user select the measure he wants to see in let´s say a table e.g.
I already created a dynamic measure that displays the selected value e.g.
"DynMeasure= switch (slicerval; 1; [actual]; 2; [DiffVsPY]; 3; [%ActVsPY];blank())
When I format the measure as "auto" I get
1: 1000
2: 10.23
3: 0.04
What I want is something like
1: 1000
2: 5.1
3: 4.2%
I want to set the format of my single measure dynamically based on the slicer selecting which underlying measure to show.
Furthermore, for a different case, I have only one measure but the format should adapt dynamically based on the value:
20
15
10
9.5
1.1
0.95
0.051
The smaller it gets the more decimals I want to show. So it is not the conditional formatting which is about coloring.
Any idea how to solve this?
Cheers
Alexander
Solved! Go to Solution.
One measue can only have one format. In your scenario, you need to the measure shoule be changed automatically based items selected in your slicer, this requirement cannot be done currently.
If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Thank you for your understanding.
Regards,
Charlie Liao
One measue can only have one format. In your scenario, you need to the measure shoule be changed automatically based items selected in your slicer, this requirement cannot be done currently.
If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Thank you for your understanding.
Regards,
Charlie Liao
Covering 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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |