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 ...
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