Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
32 | |
27 | |
24 | |
22 |