Forum Discussion

Adolfo_Espinosa's avatar
Adolfo_Espinosa
New Member
8 years ago
Solved

Column Chart/Trend Line

Hi, I am trying to build a line chart that shows a trend line of sales. Before this, I have included in my dashboard a slicer that includes "Month" dimension. This column belongs to Time table, lin...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi Adolfo_Espinosa，

     

    As I know, trend line is only support for the numeric value in X axis and you need to change the type of x-Axis to be Continuous.

     

    Then you could create a between Slicer from month 1 to 12 and a line chart with trend line.

     

    When you select the month filed from time table in between Slicer, the line line chart will show a trend line from january to the month you selected.

     

    Hope this can help you!

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi Adolfo_Espinosa，

 

As I know, trend line is only support for the numeric value in X axis and you need to change the type of x-Axis to be Continuous.

 

Then you could create a between Slicer from month 1 to 12 and a line chart with trend line.

 

When you select the month filed from time table in between Slicer, the line line chart will show a trend line from january to the month you selected.

 

Hope this can help you!

 

Best Regards,

Cherry