Track Changes of Status Over A Period Of Time

[kshabelski]

Hello!

I am working on trying to show the changes of a project status for multiple projects throughout dates. The project status can either be green, yellow, red, or discovery. The status is updated each week. I have attached a sample data for visualization. I have also attached a picture as reference for the chart. Any ideas if we need to change how we track our data would be great as well!

R=Red

Y=Yellow

G=Green

D=Discovery

[V-lianl-msft · Accepted solution]

Unfortunately, as far as I know, Power BI does not have such visual to meet your needs.

[Greg_Deckler]

@kshabelski Can you post data as text?

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.

[kshabelski]

@Greg_Deckler 

1. Manually inputted

Customer Name	September 10th	September 19th	September 27th
A	Green	Yellow	Green
B	Yellow	Red	Yellow
C	Green	Red	Green
D	Green	Green	Green
E	Yellow	Green	Yellow
F	Yellow	Yellow	Yellow
G	Red	Red	Red

2. Expected Output

Stacked Bar Chart

Y axis is Date

X axis customer name

Stacked data is The status for each date and each company

3. Explanation of how to get there

That's why I am here.