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,
How do I change the colour depending on the location on the graph,
Values that add up to 1-3 red, 4- 5 orange and 6-8 green
I have created a calculated column summing the numerical value of Priority and Effort.
These values are between 1 and 8 but I am unsure where to go from here.
Thanks in advance
Solved! Go to Solution.
Hi @Anonymous,
Based on my test, you could refer to below step:
Create measure:
Measure = SWITCH(TRUE(),CALCULATE(SUM(Table1[Iterm]))<=2,"#FF4136",CALCULATE(SUM(Table1[Iterm]))<=4,"#FFDC00","#2ECC40")And open the Advanced controls in data color to modify your color:
Hi,
I also want to use conditional formatting for a scatter chart. My current chart shows volume on the X-as and unit margin on the Y-as per customer. The customer name is shown per dot.
Additional I want to use conditional colouring on the dots for example:
Blue dots - customers from the US
Green dots- customers from Europe
Purple dots - customers from Asia
Can someone help me? Thanks
Hi @Anonymous,
Based on my test, you could refer to below step:
Create measure:
Measure = SWITCH(TRUE(),CALCULATE(SUM(Table1[Iterm]))<=2,"#FF4136",CALCULATE(SUM(Table1[Iterm]))<=4,"#FFDC00","#2ECC40")And open the Advanced controls in data color to modify your color:
Hi @v-danhe-msft, I'm using Aug 19 desktop and don't have the advanced colour option for conditional formatting (see above). Any thoughts upon why this could be please?
Yes, as @Anonymous notes, the "Advanced controls" has disappeared! Even now on May 2020 release!
Badly need transparency - please vote here, and Conditional Formatting would be great too. Bring it back urgently!
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 |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |