Forum Discussion

katto16's avatar
katto16
Helper I
3 years ago
Solved

Line Chart changing to dots

I have this line chart that shows the trend of the top 5 descriptions (Top N, of the count of description) within the span of past 3months, which I set the date filter to Relative date -> 3 calendar months. The date hierachy is Year, Quarter and Month. It looks something like this.

 However, on the following day, it will automatically change back to vertical dots unless, I change the date to date, then change back to date hierarchy, and remove Day as I wanted. Then it'll go back to the lines. It has been this way for a few days. I'm not sure what the problem is. 

Any help is appreciated. Thanks.

Need Help
  • vk_pbi's avatar
    vk_pbi
    3 years ago

    Hi katto16 

    I would recommend you to use a custom dates table and create relationship with other tables.

    You can use below DAX to create a custom calendar table

    Calendar= 
ADDCOLUMNS(
    CALENDARAUTO(),
    "Month No", MONTH([Date]),
    "Month Name", FORMAT([Date], "mmm"),
    "Year", YEAR([Date]),
    "Date Sort", FORMAT([Date],"YYYYMM")
)

    Dont forget to sort the month name with month number. otherwise it will sort by alphabatically.

    Hope this solve your issue 

5 Replies

  • VijayP's avatar
    VijayP
    Community Champion
    3 years ago

    katto16 

    in the first visual the x axis showing quarter and in the second one x axis is year 

    This is due to the use of date hierarchy in the x axis. Avoid using heirarchy instead use the required value alone in the x axis. to get rid of auto time intelligence 
    file -> options and settings-> options -> current file - > DAta load -> time intelligence (uncheck)

    Try using date dimension instead of using native date columns from the data

    • katto16's avatar
      katto16
      Helper I
      3 years ago

      Hi VijayP Thanks for the input.

      When I unchecked the time intelligence, the date hierarchy isn't available anymore. I need the hierarchy as I need to see the data by months instead of dates. I have two other pages that have the same settings with this and they don't seem to have this problem, meaning they stay as lines permanantly. 

       

      • vk_pbi's avatar
        vk_pbi
        Resolver II
        3 years ago

        Hi katto16 

        I would recommend you to use a custom dates table and create relationship with other tables.

        You can use below DAX to create a custom calendar table

        Calendar= 
ADDCOLUMNS(
    CALENDARAUTO(),
    "Month No", MONTH([Date]),
    "Month Name", FORMAT([Date], "mmm"),
    "Year", YEAR([Date]),
    "Date Sort", FORMAT([Date],"YYYYMM")
)

        Dont forget to sort the month name with month number. otherwise it will sort by alphabatically.

        Hope this solve your issue