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.
Hello
After help please, I have created the below graph, but now I want each bar to show the breakdown in colours (red, amber, green) of what amount in £ is made up by margin below 8%, what amount in £ is made up from margin between 9-15% an what amount in £ is above 15%. In my data I have the margin percentages, please see below.
Can anyone help please
thanks
Solved! Go to Solution.
Hi @KateDANI
You can consider the following solution.
1.Create a type columnin the table.
Type =
SWITCH (
TRUE (),
[Margin%] < 0.08, "0-8%",
[Margin%] >= 0.08
&& [Margin%] < 0.15, "8%-15%",
[Margin%] >= 0.15, ">=15%"
)
2.Then put the type column to the legend in the visual
Then you can set the color to the column in Columns.
Set the red color to the "0-8" and set the related color in other type.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @KateDANI
You can consider the following solution.
1.Create a type columnin the table.
Type =
SWITCH (
TRUE (),
[Margin%] < 0.08, "0-8%",
[Margin%] >= 0.08
&& [Margin%] < 0.15, "8%-15%",
[Margin%] >= 0.15, ">=15%"
)
2.Then put the type column to the legend in the visual
Then you can set the color to the column in Columns.
Set the red color to the "0-8" and set the related color in other type.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
39 | |
20 | |
20 | |
13 | |
12 |