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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
kpavan999
Frequent Visitor

X-axis Chart with 2 dimensions

Dear experts,

 

I would like to achieve something like below. Where striked off is 1 dimension and FY22 Q21 is year dimension.

If i use drill down, i dont get this instead ill get FY22 Q21-striked1,FY22 Q1-striked2.... etc

 

kpavan999_0-1627577965017.png

 

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

@kpavan999 Seems like you could build an adhoc hierarchy in your Axis field well and then use the forked arrow icon to drilldown. Can't be certain though. You may have to turn off "concatenate labels" in the X-Axis properties settings.



Follow on LinkedIn
@ 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!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

 , Thank you for your response.
I tried that, but no luck(turning off "concatenate labels" didnt work for some reason)

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors