Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date format on visualizations not matching data

Hello,   Working with data that is based on a FY-Period format, but power BI likes to auto grab it as a date, which is fine, I switched the format to yyyy-mm, which meets what I need. But when putt...
Need Help
Tips and Tricks
  • Gianluca88's avatar
    Gianluca88
    3 years ago

     

    Yes, I have had doubts about your request before. 

     

    You have to set the property of X-axis to categorical, rather than 'Continuous' like in the image

     

    Please check and let me know,

    g

     

    If you are satisfied with the answer, please mark it as solution in order to allow other user to get faster the answer to your question

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Unfortunately I can not share any of the data, sorry.

Gianluca88's avatar
Gianluca88
Resolver I
3 years ago

Hi Anonymous ,

would you like this solution?  If yes, I will explain to you how to do that job.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Don't mean this to sound rude, but yes I would like to know how to fix my issue, otherwise I wouldn't have posted it. 

    • Gianluca88's avatar
      Gianluca88
      Resolver I
      3 years ago

       

      Yes, I have had doubts about your request before. 

       

      You have to set the property of X-axis to categorical, rather than 'Continuous' like in the image

       

      Please check and let me know,

      g

       

      If you are satisfied with the answer, please mark it as solution in order to allow other user to get faster the answer to your question

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Ah, you are correct. Thank you