Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
Solved! Go to 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
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
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?
@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])
)
Proud to be a Super User! |
|
Thank you for your answer. But how can I format the axis labels? Don't they come from columns?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |