Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi
I have a line chart that is repeating my 'Year' alongside my 'Month', I want to replicate how I show years on the column chart below; I have tried changing the drill down options and different columns in my date table but cannot get it to show as the second image. Any advice?
Solved! Go to Solution.
Hi @analyst85
Disable this option under X axis setting
i hope I answered your question!
Hi @analyst85
Disable this option under X axis setting
i hope I answered your question!
thanks very much, can't believe I missed that!
Hi @analyst85
Not sure what is the problem you are facing but it can be solved by removing the Year from your hierarchy
Regards,
Ritesh
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 28 | |
| 27 | |
| 25 | |
| 22 | |
| 18 |
| User | Count |
|---|---|
| 52 | |
| 49 | |
| 43 | |
| 36 | |
| 36 |