How to create a reference staked chart

[Anonymous]

Hello!
I have a table that follows this structure:

ID	Red	Yellow	Green
ID 01	10	20	50
ID 02	60	25	30
ID 03	30	10	20

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?

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached the PBI file.

Hope this helps.

[amitchandak]

@Anonymous , Create a common dimension table ID and join with both tables and use on axis

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda