Clustered column chart with a stacked chart showing the difference

[Brianii]

I have a clustered column chart and I am wondering if it's possible to show the difference between Delivered and Count All in red (see week number 27).

[Brianii]

Hi
Thank you for taking your time to respond. Whilst it's not what I am looking for, it's the close. I'll accept this as a solution and submit the idea. Thanks

[Anonymous · Accepted solution]

Hi  @Brianii ,

Sorry, Power BI can't implement this feature for the time being, in the Clustered column chart, the colors in the column can only be the same color, and you can't add a color

You can also submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

You can add a category in [Group] to act as a Difference and display it in Visual.

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
var _table1=
SUMMARIZE(
    'Table','Table'[Index],
    "Group","Difference",
    "Value",
SUMX(FILTER(ALL('Table'),'Table'[Index]=EARLIER('Table'[Index])&&'Table'[Group]="Coun_All"),[Value])
    -   SUMX(FILTER(ALL('Table'),'Table'[Index]=EARLIER('Table'[Index])&&'Table'[Group]="Delivered"),[Value]))
return
UNION(
    'Table',_table1)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly