Forum Discussion
parvathisuku_90
Helper I
6 years agoNeed help with line chart x-axis
Line chart x-axis is skipping the values, ie, missing december , feb etc..Can some one please help.
- 5 years ago
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
Helper I
6 years agoIf I change x-axis to categorical then it is showing every date. But I need not show only months.
v-diye-msft
Community Support
5 years ago
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