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. 

prateekraina's avatar
prateekraina
Icon for Memorable Member rankMemorable Member
9 years ago

I think the issue exists in your dataset or relationships, If possible can you share images of how your data and relationships look like?

 

Thanks !!

  • lphong's avatar
    lphong
    Regular Visitor
    9 years ago

    I've tried as you suggested and only use the date on the same table (no releastionship involves). 

     

    I went to Edit Query and transform the date colum to Start of Month but it still skips the lable of the months in between. 

     

    Apparently I could convert the month name it to Text format but then it's only sortable aphabetically. Thanks for the help prateekraina