Forum Discussion

lphong's avatar
lphong
Regular Visitor
9 years ago
Solved

Graphs only display even or odd months text

Hello everyone,   I ran into this annoying issue but not sure how to fix it. I have a datekey table and created a column call BOM (beginning of month) with just simple function StartofMonth. The pr...
  • lphong's avatar
    lphong
    9 years ago

    So I created column in my Datekey table FORMAT(DateKey[Date],"MMM")&" " &DateKey[Year] to show only Month and Year.

     

    Then I set it to Categorial in the graph it works perfectly. Thanks for all the help. 

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi lphong,


Have you resolved your issue? Please mark the helpful reply as answer, or share your solution.

Thanks,
Angelia

  • lphong's avatar
    lphong
    Regular Visitor
    9 years ago

    Thanks v-huizhn-msft

     

    The only problem with your proposal is that if you format the column to Text, when you sort the month name, it will sort alphabetical. 

     

    So I created a DateKey table with Date since 2011. Then I created a month/year column, Calendar(format[Date], "MMMM yyyy"). This will make sure my Month/year column can be sorted by timeline instead of alphabet letter. However, that's where it skipped the label of the months in between. 

     

    I thought this was scaling issue but it still doesn't work when I tried to scale the visual bigger. 

     

    Still looking for solution now. Should I file a bug for this?