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.
Need help in color code bar chart according to values each bar shows. I am not able to see any roller paint option, neither fx option to change bar color according to measure.
Kindly assist.
Solved! Go to Solution.
Hi @Rituritu ,
Pls refer the below:
base data:
create visual:
Bar color =
SWITCH(
TRUE(),
MAX('Table'[value]) = 10, "#FF0000",
MAX('Table'[value]) = 20, "##00FF00",
"#000000"
)
Configuration:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi @Rituritu ,
Pls refer the below:
base data:
create visual:
Bar color =
SWITCH(
TRUE(),
MAX('Table'[value]) = 10, "#FF0000",
MAX('Table'[value]) = 20, "##00FF00",
"#000000"
)
Configuration:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
@Rituritu , if you have used Legend, you will not see fx option, otherwise you should able to see that
In bar visual how use two-axis, in place of legend
Concatenate Label off : https://youtu.be/QgI0vIGIOOk
Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://www.youtube.com/watch?v=RqBb5eBf_I4
Thanks Amit,
I have removed legend, still no option for roller paint or fx.
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 |
---|---|
110 | |
99 | |
79 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |