Power BI Clustered and Stacked Column Chart
Вставка
- Опубліковано 2 тра 2021
- 2:52 to get right into it!
Part 2 (Dynamic): • Power BI Clustered and...
This video is a quick tutorial on how to simulate a clustered and stacked chart in Power BI. This method required a manual table entry to indicate the order of the items in the axis. If you prefer to have everything as a calculation to keep the dashboard sustainable with updated datasets, please see my SkillShare class for a walk through.
2-week free trial for SkillShare: skl.sh/3xGr6RQ - Наука та технологія
Thanks for the video, it was really helps me a lot.
Thanks again!!
Very good instructions this is! I hope Microsoft adds this graph as default visual.
Its so strange that there are charts that excel can do that Power BI can't. Thanks for the video. It gave me the very lazy idea to export the chart then chuck it into excel and create a powerpivot chart which groups things automatically.
You area genius!
Is it possible to then add a line chart to this stacked and clustered?
There appears to be a new visualization called 'Clustered Stacked bar chart' that does this.
can we use this approach if we have to compare the results for different years ? first bar is for current year and second bar for different year ?
Finally i found something brilliant ! Thank you
I need to compare the previsional workload with the realized workload by day and article
So i have my 2 calculated columns "previsional workload" and "realized workload" and the columns "article" "day" are in text
How could i adapt your method to my case please ?
This is really amazing! Would you mind sharing how you did the product name title in the center underneath the two country names you have? For example, on your initial report, "Paseo", "VIT", "Velo" etc. are all in the center underneath the charts... did you do that manually or is there a way to do that automatically in Power BI?
Luckily that's a Power BI function! Under the visualization pane, go to format, X axis, and turn off "Concatenate Labels".
This only works if you're sorting the graph by the x-axis and you're drilling down (which we are in this case)
@@ellenimamura9353 Thank you so so much... and thank you again for the video, I've been wanting a solution like this for over 4 years now!
Congratulations, you are a genius!
An incredibly effective solution, Microsoft should reward you!
Instead, I was delusional that I solved it by overlapping 2 lined and stacked column charts so that they looked clustered. I was thinking of solving the problem of proportionality on the Y axis by means of a transparent line drawn on the maximum.
Unfortunately, the rendering between the PowerBI Desktop application and the WEB service are different so the proportions on the Y axis are out of phase.
THANK YOU for your solution :-)
So glad I could help and thank you for the kind words!
Why is this in the 442oons factor playlist
i don‘t like cover ups