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

[Anonymous]

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:

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

Thank you in advance for you help

[govind_021 · Accepted solution]

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.

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

[Anonymous]

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]

@Anonymous , 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])
)

[Anonymous]

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