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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
pbiuser452
Frequent Visitor

Clustered Column Chart with multiple fields in the x-axis

Hey Everyone,

 

Im having issues with having multiple values in the x-axis on the clustered column chart. Currently it looks like this:

 

pbiuser452_0-1728915788918.png

 

I just want to have a Blank, INVOK, INV, and DRPN sections, not all the (blank) DRPN (blank) sections as its doing now. 

 

Is there a way to make it just have 4 clustered columns instead of the 6 it has now?

3 REPLIES 3
Anonymous
Not applicable

Hi, @pbiuser452 

Merry Christmas to you. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

 

 

Best Regards

Jianpeng Li

Anonymous
Not applicable

Thank you Kedar_Pande 

Hi, @pbiuser452 

Based on your description, I created the following sample data:

vjianpengmsft_0-1728973898740.png

In the clustered column chart, you would adjust the fields as follows:

vjianpengmsft_1-1728974011005.png

I have attached the PBIX file used this time below.

 

 

 

Best Regards

Jianpeng Li

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

Kedar_Pande
Super User
Super User

Please share the file so I can have a closer look.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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