Forum Discussion
Helper INeed help with line chart x-axis
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
Community Championparvathisuku_90 You need to change from Continuous to Categorical in your x-axis.
Helper IIf I change x-axis to categorical then it is showing every date. But I need not show only months.
- dedelman_clng
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
- v-diye-msft
Community Support
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
