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 have a switch function where i switch between whole numbers and percentages. This switch function is inside a matrix with conditional formatting.
I need the the the switch fucntion to display as a whole number, and the percent to display as a percentage. Unforuntatly the Format() function doesn't work for me because it converts the value to text and therefore my conditional formatting doesn't work. Are there any workarounds to this?
Solved! Go to Solution.
Hi @Anonymous
Create measures, then configure conditional formatting for Measure using the Measure 2
Measure = IF(SUM(Sheet2[value])=INT(SUM(Sheet2[value])),FORMAT(SUM(Sheet2[value]),"General Number"),FORMAT(SUM(Sheet2[value]),"Percent")) Measure 2 = IF(SUM(Sheet2[value])>1,1,0)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi - you can do that now in Power BI.
Here is my tutorial on how to do that:
Hi @Anonymous
Create measures, then configure conditional formatting for Measure using the Measure 2
Measure = IF(SUM(Sheet2[value])=INT(SUM(Sheet2[value])),FORMAT(SUM(Sheet2[value]),"General Number"),FORMAT(SUM(Sheet2[value]),"Percent")) Measure 2 = IF(SUM(Sheet2[value])>1,1,0)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |