Forum Discussion

lukaspowerbi's avatar
lukaspowerbi
Icon for Helper II rankHelper II
8 years ago
Solved

Line chart

I am using a line chart visual: x axis - months y axis - number of tickets   I would expect my line chart display months in a chronological order Jan Feb Mar, etc.,however, the first month on my ...
Need Help
  • pawel1's avatar
    pawel1
    8 years ago

    1. add Month and Year columns to your table, reference to [Date] column:

        Month = Sales[Date].[MonthNo]

        Month Name = Sales[Date].[Month]

        Year = Sales[Date].[Year]

     

    2. sort the 'Month Name' column by 'Month'

     

    3. use the double arrow to expand the graph to Months

     

pawel1's avatar
pawel1
Icon for Kudo Kingpin rankKudo Kingpin
8 years ago

similarly, but without using Advanced Query.  Add 2 columns to your table: Month and Year (both numerical).

In visualisation, place Year and Month in Axis.  Jan-2018 is shown as last:

 

 

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Nice, I forgot that Line charts now have drilldown!

 

It's not a bad idea to add that MonthSerialID column anyway though.  It's very handy for doing calculations for trailing 12 months.  That way you can grab the most recent 12 months, regardless of which year they're in.

  • lukaspowerbi's avatar
    lukaspowerbi
    Icon for Helper II rankHelper II
    8 years ago

    So it seems that adding 2 columns to my table would be easier, would you give me an example with my case?

    Not very fammiliar with DAX language yet.

    • pawel1's avatar
      pawel1
      Icon for Kudo Kingpin rankKudo Kingpin
      8 years ago

      1. add Month and Year columns to your table, reference to [Date] column:

          Month = Sales[Date].[MonthNo]

          Month Name = Sales[Date].[Month]

          Year = Sales[Date].[Year]

       

      2. sort the 'Month Name' column by 'Month'

       

      3. use the double arrow to expand the graph to Months