The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 putting the data into a chart, it changes the format to full length month year format "March 2022" for example, which is misleading for my data. Just curious why having the format changed in the data would not change it for the visuals, all the other posts I found on here pointed towards that being the solution.
Thanks for any help.
Solved! Go to Solution.
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
I have pulled my hair out in frustration over this lack of proper date format handling in Power BI visuals. Excel has much better features in its charts when it comes to date display format.
Hi @Anonymous ,
please could you share a simple pbix file in order to work on it?
Many thanks,
g.
Unfortunately I can not share any of the data, sorry.
Hi @Anonymous ,
would you like this solution? If yes, I will explain to you how to do that job.
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.
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
Ah, you are correct. Thank you