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