- 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

Bar like Visual
Been looking into the various visualtions and tools for Bar Chart like visual, but thus far have not found what I am looking for.
For context, we have several products, lets say A/B/C/D and each product has X number of processes, which may defer from product to product. For each product, the processes are squential meaning 1 has to finish before 2 starts and so on. And the outcome of the process can be red/green/grey.
Example Data:
Stage | Process | Status |
A | 1 | Red |
A | 2 | Red |
A | 3 | Green |
A | 4 | Red |
A | 5 | Grey |
A | 6 | Red |
A | 7 | Green |
A | 8 | Red |
A | 9 | Red |
A | 10 | Red |
A | 11 | Green |
A | 12 | Green |
A | 13 | Green |
A | 14 | Green |
A | 15 | Green |
A | 16 | Green |
A | 17 | Grey |
A | 18 | Grey |
A | 19 | Green |
A | 20 | Green |
A | 21 | Green |
A | 22 | Green |
A | 23 | Green |
A | 24 | Grey |
A | 25 | Grey |
A | 26 | Grey |
B | 1 | Red |
B | 2 | Red |
B | 3 | Red |
B | 4 | Grey |
B | 5 | Grey |
B | 6 | Green |
B | 7 | Red |
B | 8 | Red |
B | 9 | Red |
B | 10 | Red |
B | 11 | Green |
B | 12 | Green |
C | 1 | Green |
C | 2 | Green |
C | 3 | Green |
C | 4 | Green |
C | 5 | Green |
C | 6 | Green |
C | 7 | Green |
C | 8 | Green |
C | 9 | Green |
C | 10 | Green |
C | 11 | Green |
C | 12 | Grey |
C | 13 | Grey |
C | 14 | Grey |
C | 15 | Red |
C | 16 | Red |
C | 17 | Red |
C | 18 | Red |
C | 19 | Red |
C | 20 | Red |
C | 21 | Red |
C | 22 | Red |
C | 23 | Red |
C | 24 | Red |
C | 25 | Green |
C | 26 | Red |
C | 27 | Red |
Using the "Bullet Chart" one can get a bar chart, but there is no control on the color
When using the "Bullet Chart by xViz" there is some control of the color, however, it does the count and does not treat the color as a distinct entity
Expected/Required Output
As suggessted by @Greg_Deckler Updated to include data and some additional context
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Aly ,
You can get the expected output by Matrix and conditional formatting.
Best regards,
Mengmeng Li
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Aly ,
You can get the expected output by Matrix and conditional formatting.
Best regards,
Mengmeng Li
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@v-mengmli-msft thanks. I think I was just blindsigthed thinking of it purely as a bar chart.
The initial setup is daunting especially if the conditional formating spans a lot. Too bad there is no Legend functionality to it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Aly Can you post sample data? Maybe a scatter plot chart could be used for this.
Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Added context. I hope this is now inline with the forum.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Aly I was able to use a Scatter chart to get what you wanted. However, you need to use numbers for your stages instead of text. See attached PBIX file below signature:
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Greg_Deckler Thats a way of looking at it, unfortnately without the name on the x-axis it is fairly difficult to read for the people who it is intended for.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Aly Yeah, unfortunately it's a limitation to the scatter chart. You might be able to do something with Deneb or other third-party visuals.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-06-2025 09:15 AM | |||
02-08-2025 01:44 AM | |||
01-05-2025 06:29 PM | |||
10-25-2024 09:38 PM | |||
08-30-2024 01:50 AM |
User | Count |
---|---|
137 | |
107 | |
84 | |
59 | |
46 |