Forum Discussion

mellas_k's avatar
mellas_k
Helper 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 …, can someone help me to display the first graph with only all months and without calculate the sum.

Thanks for your help

Need Help

12 Replies

  • dilumd's avatar
    dilumd
    Impactful 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
      Helper I
      9 years ago

      hi dilumd

       

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

      thanks 

      • dilumd's avatar
        dilumd
        Impactful 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.

          

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

      Hi mellas_k,

       

      Change the X-axis type to Continuous as is shown in above screenshot will show all twelve months on axis. So what did you mean 'see all the months' and what is your current result after setting type to Continuous?

       

      Best regards,
      Yuliana Gu

      • mellas_k's avatar
        mellas_k
        Helper I
        9 years ago

        Hi v-yulgu-msft

        When i change the  X-axis i have the below result 

         

        And i need to show all 12 monthes .. 

         

        thanks for your help.