Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi! I'm trying to adjust the date-format for my x-axis, but when I do so it doesn't adjust the display of the date. I've tried restarting the software, opening and closing the file, I just can't get it to work. Can you help? Thanks!
I believe you are using the date heirarchy on your x-axis. This will not use the format you've applied on the columns in the formatting section. You can try right click on the "Created" and use the non-Heirarchy value, or use the FORMAT function to get the text you want. This post on SQLBI might be useful to you: https://www.sqlbi.com/articles/improving-temporal-line-charts-in-power-bi-with-dax/
Hello vicky_,
thanks for helping! I think I get what you're saying. However, because my data has repeated values as well as gaps, PowerBI indicates that I can't turn it into a Date Table. Could you provide advice as how to proceed from here? Thanks again!
Can you create your own date table using CALENDARAUTO()? Create a relationship between that one and the Created field in your data and then use that instead.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |