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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Kap
Regular Visitor

clustered column chart

Hi,

 

I have a requirement to create 'clustered column chart'. In that I have to have 2 columns at the X-axis.

 

Ex: On X-axis I should have Region and City. Cities should be grouped under respective region and show sales data.

 

Please help me with this.

 

Thank you.

4 REPLIES 4
Kap
Regular Visitor

Thank you @Greg_Deckler and @Anonymous

 

I will try this.

Kap
Regular Visitor

Thank you @smoupre and @B129.

 

This trick worked !!!

Anonymous
Not applicable

Hi @Kap,

 

   here is an example of what @Greg_Deckler tolds you.

(I've used state/city to simplify)

 

drillDown.png

 

I've changed the "Date Category" of State and City to make them more efficient.

 

#I'M Not An Expert#

Greg_Deckler
Super User
Super User

With a clustered column chart, if you put two things in the x-axis, you will be able to "drill into" the columns. Alternatively, place Region in x-axis and Cities in Legend, then you will get both on the x-axis grouped by region.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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