Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
30 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
35 |