Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
How can I make it such that I am using stacked bar chart but I want it to be combined in 1 graph like the one below? I can only manage to find one sort of visualization like that in PowerBI but the one below is quite unappealing. Does anyone know how to make it like the chart below using a more appealing chart like the line and stacked chart?? ( I tried but using the legend only allow me to add one column)
Solved! Go to Solution.
Hi @kitala11 ,
I suggest you transform your table to the following format(unpivot the last three columns):
Then it will act like what you want:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hello @kitala11
If forecasts are the measures then you can add them into the values.
Try and check or you can provide the sample data after removing sensitive data.
I am adding them into values. However, I need to proj aprov to be in the legend for the stacked columns. The thing is if i have something in the legend. The values can only contain 1 (measure/column). Which is shown as the first top photo, that is how it looks like if I do it the way you are saying
that is exactly what I have.... which i mentioned that i am looking for other options because it is not presentable
Hi @kitala11 ,
I suggest you transform your table to the following format(unpivot the last three columns):
Then it will act like what you want:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
As per my knowledge Power BI doesn't allow multiple values if you don't put values in the axis and if you put the only legend it will allow one value only.
You may try custom visual "Multiple Axis Chart - xViz"
Here is a sample data, you can imagine it for a few more months, but that is what the data looks like, besides the numeric value being altered by me.
What is the final objective is most important to give a solution!
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |