Forum Discussion
Stack only single bar in bar chart
Can you share me a google drive folder, where I can upload the file? I tried it on my side and it works. Just open it with Power BI Desktop
Hi,
It can be easily implemented, depending however on your data model. If you have fields Type (Original Cost, spend to date, remaining, etc.) and value (100, 80, etc.) you can create a grouping table (excel or enter data in Power BI as new table) like:
| Type | Grouping |
| Original Cost | Original Cost |
| Spend To Date | Total Cost |
| Remaining Cost | Total Cost |
| etc. | etc. |
Connect this new table with the existing one over type. Then you can create a stacked bar chart with Grouping on the Y axis, Value on X axis and Type on Legend.
Regards,
Oktay
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
I need same expected output as shown in excel. I want two bars stacked seperately in single line with values and total cost at the end. Please provide a detailed answer please with Pbix file.
Thanks