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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Remove previous drill up label on X-Axis

I have an bar graph that shows Quarter -> Month on X-Axis and the user can drill up/down between these two, but when selected "Month" i wanted to show only the "Month" label, not "Quarter + Month" on X-Axis. I already disabled "Concatenate Labels" on "X Axis" option but it doesn't change anything.

 

My X-Axis look like this when selected "Month", i just wanted to show "08-2021", "07-2021"

 

hesloan_0-1629898795864.png

 

4 REPLIES 4
v-eqin-msft
Community Support
Community Support

Hi @Anonymous ,

 

If the Quarter is not necessary, you may remove it from X-axis field?

Could you please share me with your pbix file after removing sensitive data to help us clarify your scenario?

 

Best Regards,
Eyelyn Qin

Anonymous
Not applicable

I'm having problems uploading the .pbix file, it says that its not supported, but i've created a simple example.


Thats my database (date / valor)

hesloan_0-1630432399019.png

 

And i wanna show, in a bar graph, values for each quarter and drill down for month, but i wanna show only the "month" label on X-Axis when drilling down.

 

Right now it shows me like this (Quarter + Year + Month)

hesloan_1-1630432503912.png

So, this when looking at quarter:

hesloan_2-1630432738619.png

 

And this when drill down to month: (month year)

hesloan_3-1630432915293.png

 

 

VahidDM
Super User
Super User

Hi @Anonymous 

 

I think this link can help you:

https://community.powerbi.com/t5/Desktop/X-Axis-Label-Hierarchy/m-p/841928

 

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos VahidDM_0-1629899468438.png !!

Anonymous
Not applicable

Hey @VahidDM , i already disabled Concatenate labels on "X Axis", but still have Quarter + Month on my visualization. These Quarter and Month are text data type, not date data type, i dont know if this can be a problem.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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