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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Man-olis
Regular Visitor

Don't Show Year in X-axis when Drilled Down to Month Level

Hello all,

 

I have this issue and I have tried using conditional formatting to solve it but I can't figure out a way.

I have a graph like the one below that has the Years in the x-axis and you can drill down to the Month level:

Manolis_2-1733302185556.png

 

I just don't want to show the year (circled in the below screenshot) when I have drilled down to the Month level 

Manolis_0-1733302119296.png

 

Thank you in advance for you help

1 ACCEPTED SOLUTION
govind_021
Resolver II
Resolver II

Hi  
Please have a look below You must have concatenate labels in X axis of the chart - Turn off
Please trun it on and year label will be gone as shown in below screenshot 

If your problems solves please make it as solution.

 

govind_021_2-1733305081357.png


Best Regards,
Govind Sapkade
Data Analyst | Power BI Enthusiast | Microsoft PL 300 Certified Power BI Data Analyst | MS Fabric Enthusiast
🎥 Subscribe to my youtube channel for hands on tutorials : https://www.youtube.com/@govind_dataanalyst

📊 Let’s connect on Linkdin : www.linkedin.com/in/govind-sapkade-845104225

View solution in original post

4 REPLIES 4
govind_021
Resolver II
Resolver II

Hi  
Please have a look below You must have concatenate labels in X axis of the chart - Turn off
Please trun it on and year label will be gone as shown in below screenshot 

If your problems solves please make it as solution.

 

govind_021_2-1733305081357.png


Best Regards,
Govind Sapkade
Data Analyst | Power BI Enthusiast | Microsoft PL 300 Certified Power BI Data Analyst | MS Fabric Enthusiast
🎥 Subscribe to my youtube channel for hands on tutorials : https://www.youtube.com/@govind_dataanalyst

📊 Let’s connect on Linkdin : www.linkedin.com/in/govind-sapkade-845104225

Thank you. That works mostly fine. Do you know if there is a way to do it so that only in specific situations (specific filters are applied) hides the year?

bhanu_gautam
Super User
Super User

@Man-olis , Try using 

Use DAX to create a measure that returns an empty string when the drill-down level is at the month. You can then use this measure in your visual to conditionally format the axis labels.

 

AxisLabel =
IF(
HASONEVALUE('Date'[Month]),
"",
MAX('Date'[Year])
)




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






Thank you for your answer. But how can I format the axis labels? Don't they come from columns?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.