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 Team,
I need to create dashboard showcasing the measure with monthly numbers, but facing few challenge
1. How to show Thousand Separator for $ amount
2. How to color-code based on Comparing Target value, some Measure has to be lower and some have a Bigger target
Measure Name | Target | Jan-20 | Feb-20 | Mar-20 | Apr-20 |
Dollar Saved | $8,000 | $28,732 | $30,900 | $33,483 | $43,893 |
% Customer Satisfaction | >85 | 89 | 90 | 87 | 95 |
# of New Employees | <1000 | 89898 | 5000 | 250 | 500 |
Saved Hrs on deployment | >3hrs | 7hrs | 8hrs | 4hrs | 8hrs |
Hi @Anonymous
The thousand separator is standard functionality and can be found at:
If the "normal" conditional formating is not sufficient, you can you the option "Format by Field value", this allows you to assign colors for any custom calculation:
Jan
if this is a solution for you, don't forget to mark it as such. thanks
Hi JustJan,
Standard Thousand seperator functionality not work as mine columns contains different format like %age, $, # and hrs value. So is there any other way ?
Some Measure created by using formula
"$"& Text.From (Number.Round ([#"Field Name"],2))
Or
Text.From (Number.Round([#"Incidents"]*100,2)) & "%"
For color coding you have suggested the static while I'm trying to find a dynamic so If Target changed the color coding changed and also looking to code based on % range
Green: equal or below the target and with a less than 5% Variance above target. Amber: Above 5% variance of the target. Red: Above 10% variance of the target
OR
Green: equal or above the target and with a less than 5% Variance above target. Amber: Above 5% variance of the target. Red: Above 10% variance of the target
hI @Anonymous
It seems that you calculate your "measure" in m-query.
When you use" Number.ToText(12345,67,"N") you will get a text "12,345.67"
The code I suggested is merely an example, you can put any measure / expression that leads to True() (in this case), but if I understand you threshold correctly, than you can use the standard conditional formating by rule, use your calculated percentage in the rules.
There is also an option to use percent in the rule, but that does not allow for negative values.
So your percentage calculation now drives the colors in the conditional format
Jan
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |