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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
GWMnlarose
Frequent Visitor

Multiple Axis (categories) in PBI Chart

Hi all,

I am re-creating a series of pivot charts in Power BI.

The charts have multiple axis which will show me the downtime reasons per machine by shift. (A00 shift, 808 machine number)

I am having trouble getting this in Power BI.

 

I have found a way where it will display a second axis but rather than grouping by the second axis it displays it next to. EG (A00 Bin Change, A00 Wait FLT, etc)

 

Can anybody help with this or is the feature not supported in PBI (I hope it is!)

Thanks CNC Picture 1.JPGCNC picture 2.JPG

4 REPLIES 4
Hariharan_R
Solution Sage
Solution Sage

Hi

As per my understanding you can acheive like below.

c1.PNG

Hi Hariharan,

Thank you for helping. I have tried doing that but I am unable to group all the A00 and B00 together - only one at a time?

GWMnlarose_0-1654692206510.png

 

Hi @GWMnlarose ,

Could you please tell me on which fields you are sorting your column chart? Could you please provide a screenshot similar to the one below?

yingyinr_0-1654849530765.png

Best Regards

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

Hi Rena,

Thank you for getting back to me.

Please see below. I have clicked and get the below results. It may be the case that such setting is not available in Power BI. if there is a way I can send you the excel file I am trying to replicate.

 

GWMnlarose_0-1655110940099.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.