Creating a half stacked bar chart to display (Sales + Pipeline) vs. Quota

[Anonymous]

Hi,

I am trying to display in a horizontal bar chart (YTD Sales + Pipeline for the rest of the year) vs. Quota for the rest of the year. Ideally the Sales + Pipeline bar would be stacked with different colors (preferably dotted for pipeline) showing which is pipeline and which is sales. Then the quota bar next to it would be one color. Is there a "half stacked" bar chart that I could use or a workaround that anyone has done? My Y axis in this scenario is year, this data is coming from three different tables so I'm not sure I could add a category to the Y axis to split it up, but maybe I could. Thank you in advance for your help.  

[Anonymous]

Hi @Anonymous ,

What's your expected result? Which one is your expected result in the below screen shots?

Sample 1

Sample 2

Best Regards

Rena

[Anonymous]

Sample 2 is my exact expected solution! How did you configure this?

[Anonymous]

Hi @Anonymous ,

First, you can create one calculated column or measure to calculate the aggregate value of annual Sales and Pipeline value. Then drag the fields Year for Axis field and Quota && new created measure/calculated column for Value field.

Best Regards

Rena

[Anonymous]

Thank you for this response, but this is slightly different than your sample 2 screenshot. I need the sales and pipeline data to be in the same bar, but different colors to show what is pipeline and what is sales already closed. Like the screnshot below you took. 

[Anonymous]

Hi @Anonymous ,

For your information, I didn't find a suitable visual object to display the data just like Sample 2 (actually it is created by drawing tool).You can summarize the sales and pipeline values as I mentioned in my previous post, the summary values and quota values are displayed on different lines or display the values of sales, pipeline, and quota on different lines as below screen shot.

Best Regards

Rena

[parry2k]

@Anonymous not sure what you mean by 1/2 bar stack chart, with DAX calculation you can make divide the value in half

Ask anything Power BI. Book free appointment at https://www.perytus.com