Bar like Visual

[Aly]

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 

[Anonymous · Accepted solution]

Hi @Aly ,

You can get the expected output by Matrix and conditional formatting.

Best regards,

Mengmeng Li

[Aly]

@Anonymous 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. 

[Greg_Deckler]

@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.

[Aly]

Added context. I hope this is now inline with the forum. 

[Greg_Deckler]

@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:

[Aly]

@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. 

[Greg_Deckler]

@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.