Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Belvicus
New Member

Split X-Axis with stacked columns

Hello,

I need to split in two different columns this chart:

 

pbi-20220620.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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:

 

pbi-20220620-deatiled.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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!

2 REPLIES 2
v-zhangti
Community Support
Community Support

Hi, @Belvicus 

 

You can try the following methods.

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

vzhangti_0-1655969211272.png

vzhangti_1-1655969253292.png

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.

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

20220623_Table021XF.jpg

 

 

 

 

 

 

 

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


Regards

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors