Forum Discussion

parvathisuku_90's avatar
parvathisuku_90
Icon for Helper I rankHelper I
6 years ago
Solved

Need help with line chart x-axis

Line chart x-axis is skipping the values, ie, missing december , feb etc..Can some one please help.  
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    5 years ago

    Hi parvathisuku_90 

     

    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's avatar
parvathisuku_90
Icon for Helper I rankHelper I
5 years ago

If I change x-axis to categorical then it is showing every date. But I need not show only months.

 

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
5 years ago

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