How to merge 2 columns in one Bar chart

[Anonymous]

Hi All,

Compare data with constant value

I need to design a bar chart visual such that , In the center I need to display a single bar(Red bar as shown in Fig.) that shows average of Org level attrition and on left side of respective bar ,it should show attrition value higher than red bar value and on right side it should show respective lesser value of attrition . Is it possible ?
or is there any other visual available for above requriment. If YES then please suggest me or NO then why.

Note- Org average values are coming from another table and whereas SBU values are from another.

[v-sihou-msft · Accepted solution]

@Anonymous

No, it's not possible to make the Avg as a bar/column in a column chart. You can't have the aggregation result of entire table appeared on row level.

For your requirement, I suggest you try column+line combo chart. You can create a measure to calculate the Average for all selected entries, and put it into Line values. Then you can see which column is above or below this line. 

See my sample below:

Regards,