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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
102 | |
78 | |
35 | |
35 |
User | Count |
---|---|
156 | |
103 | |
71 | |
66 | |
53 |