Forum Discussion
How to create a reference staked chart
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?
Hi,
Please find attached the PBI file.
Hope this helps.
2 Replies
- Ashish_MathurSuper User
- amitchandakSuper User
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