COMBINE CLUSTERED AND STACKED COLUMN CHART/BAR CHART INTO ONE VISUAL WITH LINE VALUES IN POWER BI

In This Video -
- How do you combine stacked and clustered charts in Power BI?
- How do I combine clustered and stacked bar charts?
- How do I put a clustered column next to a stacked column?

Get Help into Questions Related to #powerbi , #dax , #powerquery Power BI #datamodeling , #analysisservices and #powerbiservice

Our videos are mostly specific to real time challenges faced into Power BI projects and its solutions. We use smart and most efficient techniques to solve such challenging situations in Power BI and DAX.

Checkout our playlist and SUBSCRIBE to our channel, for all such interesting topics in Power BI.

Follow us on LinkedIn
@POWERBIHELPLINE

[josevicentemelo]

This video was so helpful for my Internal Audit Department. It helped us compare the budget vs actual hours per phase (planning, fieldwork, reporting and wrap up) in each of the different engagements. I struggled a lot to create the chart before finding this video. Much thanks!

[LisaPrice-qb]

Great help, thank-you. I changed mine to a Stacked bar chart and I found that I can leave out the blank column, and just use the 'Horizontal' Gridlines, as a separator. Looks better than having the gap.

[mrhansros]

Thank you very much for this tutorial. It works! May God bless you

[katerinashevtsova]

As the X axis has two columns from unrelated tables I face the error Can't determine relationships between two fields and the visual is not shown. I have read in documentation that its not possible to change it. Could You please advice the direction? I don't have a sample to send.

[DEONDUPREEZ]

This is simply brilliant - works like a charm!!!

[vipul]

Very helpful! However, I am able to use this trick to create the complete vizual except when I make the spacing 0, it also removes the space between the categories (country in your example and month in my data). Any suggestions?

[AbhishekZagade]

Really Great video. This used for real time scenarios

[v.vivekthamilarasan]

Awesome! Thanks for the video! its really helpful!
Is there a way to remove those two x axis label(sales and forecast) just to keep only country? Also, data label is not visible for less stacked bar. Is there any option to show case that too? Appreciate your help!

[csabasoros]

Thanks for the video, very useful. Although I cannot make the chart drill-able up and down with the arrows, in case I wanted to add another aspect to the X axis, for me it can only jump to the lowest hiearchy drill. How do you make the created chart drill-able up-down, if you wanted to add additionally to Country also e.g. Segment to the X axis? Thanks!

[edwinarchico]

excellent, another helpful video, kudos to you 👏

[rahulmg]

Thank you for sharing this video, i have an issue with the Blank measure, when i drag the measure to Y-axis, my x axis gets wider as i have three categories /columns( clientname, year & month) on x axis. how can i show only the results for slicer I selected on the page?

[chanduvengaladasu]

"It's so grateful. I also tried to use line charts including the above, but I couldn't see the curve on the chart. Could you please help me with this? How can I add curves here?"

[katerinatishchenko]

This video is incredibly helpful and powerful!

[kavita]

Nice video but how do we create relationship between NEW AXIS and other tables so that we can calendar and new axis on X axis?

[jenschkies]

Was very helpful for me, thanks for the detailed explanation.
I do have one question: is there any way to sort the columns by forecast amount?

[kalyanreddy]

is it possible to create like Total Sales as Background Transparent and front shows split by legend. Is it possible in Power BI? Excel we can Create

[sriramya]

Hello, Thanks for your video, I have done all the steps correctly, but I am getting this error message and cant display the visual, please find the message here " MaxScript(Model) (53, 5) Calculation error in measure Raw R Total External Invoices): DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values ", Can you please help me in resolving this issue ? Thanks in advance!

[Jgrohows]

How would you get the country name to be centered underneath the Sales/Forecast columns?

[John_]

How would you do this if your x-axis is using a master calendar which you use to drill down from year, quarter, month, day?

[sabino]

Genius. But I still have a lottle visualization problem : on the x-axis I put dates and categories. In the visual I correctly see the dates but I don't want to see anything else. How to do it? Thanks a lot