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.
Hello Guys, I have face an issues based on conditional formatting. Hope you can help
What I plan to do know is, when I click on "believe" (shown as 1 below), the highest number in the table should show th darkest red, and smallest number should show lightest red
On the other side, when i click on "not believe" (shown as 2 below), the highest number in the table should show darkest green, else, lightest green
Solved! Go to Solution.
Hi @YongZhao ,
Gradients in conditional formatting cannot currently change color gradients dynamically.
As a workaround, You could create a measure, define color intervals, and apply it to conditional formatting.
For example, here I define three intervals.
Measure =
var _max=MAXX(FILTER(ALLSELECTED('Table'),[Type]=MAX('Table'[Type])),[Value])
var _value=SUM('Table'[Value])
var _red=SWITCH(TRUE(),_value>0&&_value<=_max/3,"#FDC2C2",_value>_max/3&&_value<=_max/3*2,"#FD6E6E",_value>_max/3*2&&_value<=_max,"#FD0000")
var _green=SWITCH(TRUE(),_value>0&&_value<=_max/3,"#CCFECC",_value>_max/3&&_value<=_max/3*2,"#86F986",_value>_max/3*2&&_value<=_max,"#00FF00")
return SWITCH(SELECTEDVALUE('Table (2)'[Believe or Not believe]),"Believe",_red,"Not Believe",_green)
Click the "fx" under the cell elements.
Select Based on the measure I created.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @YongZhao ,
Gradients in conditional formatting cannot currently change color gradients dynamically.
As a workaround, You could create a measure, define color intervals, and apply it to conditional formatting.
For example, here I define three intervals.
Measure =
var _max=MAXX(FILTER(ALLSELECTED('Table'),[Type]=MAX('Table'[Type])),[Value])
var _value=SUM('Table'[Value])
var _red=SWITCH(TRUE(),_value>0&&_value<=_max/3,"#FDC2C2",_value>_max/3&&_value<=_max/3*2,"#FD6E6E",_value>_max/3*2&&_value<=_max,"#FD0000")
var _green=SWITCH(TRUE(),_value>0&&_value<=_max/3,"#CCFECC",_value>_max/3&&_value<=_max/3*2,"#86F986",_value>_max/3*2&&_value<=_max,"#00FF00")
return SWITCH(SELECTEDVALUE('Table (2)'[Believe or Not believe]),"Believe",_red,"Not Believe",_green)
Click the "fx" under the cell elements.
Select Based on the measure I created.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
65 | |
64 | |
56 | |
39 | |
27 |
User | Count |
---|---|
85 | |
59 | |
45 | |
43 | |
38 |