Split X-Axis with stacked columns

[Belvicus]

Hello,

I need to split in two different columns this chart:

I need to have two columns for each month:

1. Azure + Blue values column
2. Pink + Red values column

so, for example I need to display this one,  when I decide to drill over a month this graph:

Actually I have in the axis:

• X-Axis: Month
• Y-Axis: Force and Force KO (Azure and Blue) and Training and Training KO (Pink and Red)

Please, can you help me?

Thanks in advance!

[v-zhangti]

Hi, @Belvicus 

You can try the following methods.

Index = IF([Category]="Force"||[Category]="Force KO",1,2)

Does this meet your desired outcome?

Best Regards,

Community Support Team _Charlotte

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

[Belvicus]

Hi @v-zhangti 

on first thanks for the answer.

I'm not able to apply your solution, because all the four columns are new calculated columns.

This is a part of the table

So how can I split the whole?
Thanks again for the support.

Regards