- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Help please
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
04-19-2024 08:50 AM | |||
09-03-2024 03:24 PM | |||
05-28-2024 09:51 PM | |||
08-29-2024 01:50 AM | |||
09-10-2024 02:20 AM |
User | Count |
---|---|
27 | |
27 | |
25 | |
13 | |
10 |
User | Count |
---|---|
24 | |
19 | |
16 | |
13 | |
10 |