Forum Discussion

mellas_k's avatar
mellas_k
Icon for Helper I rankHelper I
9 years ago

Display only date on the graphe

Hello , I have the below  graph and I need to show on Axe X only all months   But my problem that when I choose   I have the below graph: So I have the sum of all months …, ca...
Need Help
dilumd's avatar
dilumd
Icon for Impactful Individual rankImpactful Individual
9 years ago

Hi 

 

Try to use Format And Month functions to get the month name and then use it as the x axis’s. 

mellas_k's avatar
mellas_k
Icon for Helper I rankHelper I
9 years ago

hi dilumd

 

I tried to get the month name but I have the same issue ..

thanks 

  • dilumd's avatar
    dilumd
    Icon for Impactful Individual rankImpactful Individual
    9 years ago

    Hi

     

    what if you change the graph formatting as below, (drill down up to date level but the date want shows up. I think this came up with a new update, if you don't see it please update power BI desktop to latest version.

      

    • mellas_k's avatar
      mellas_k
      Icon for Helper I rankHelper I
      9 years ago

      HI dilumd 

      thanks for your answer , yes i did it but my boss wants to see all the months .. 

      i have not the choice ..