The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Line chart x-axis is skipping the values,
ie, missing december , feb etc..Can some one please help.
Solved! Go to Solution.
1. You can add the calculated column = month(table(date))
Then put it to the x-axis and set the type as continuous.
2. You can create a calendar table and manage the relationship with fact table, then use the date as xaxis
@parvathisuku_90 You need to change from Continuous to Categorical in your x-axis.
If I change x-axis to categorical then it is showing every date. But I need not show only months.
1. You can add the calculated column = month(table(date))
Then put it to the x-axis and set the type as continuous.
2. You can create a calendar table and manage the relationship with fact table, then use the date as xaxis
Hi @parvathisuku_90 - that is the known and expected behavior of the X axis on line charts. You may want to consider removing gridlines from the X-axis, if the "missing" months are going to be too distracting to your users.
David
Hi @parvathisuku_90 -
This behavior is because your X-axis is set to "Continuous", not "Categorical". You can switch it to categorical, but then every date entry gets its own spot on the axis and it may introduce a scroll bar as the data extends out to the right.
Hope this helps
David
@parvathisuku_90 , When axis type is continuous, line visual skips months. The other option is categorical
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
270 | |
129 | |
123 | |
100 | |
92 |