Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to create a reference staked chart

Hello!
I have a table that follows this structure:

IDRed   Yellow   Green   
ID 01   102050
ID 02602530
ID 03301020


I want to create a staked chart that will serve as a reference, as it will show the colors (red, yellow and green) based on the table column values ​​and always in that order. This chart will be a reference, as I will relate this table with another table that has the quantity amount in stock and show the actual amount on top of the reference chart.

For example, let's say the stock values ​​for each ID in my other table are:

ID 01 = 100
ID 02 = 23
ID 03 = 40

My chrat should look like this:


Is this possible to do in Power BI?

2 Replies