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.
Good day
I'm trying to remove 2022 from the ETA and show all the days on the X-axis
Thanks in advance !
Solved! Go to Solution.
HI @Lyle ,
Have you got a date hierarchy on your bar chart?
If you have a date hirarchy then you can drll down to day level and show days on the x-axis. Something like below:
The other way could be just to move the day part from your date column on the x-axis if you don't need a drill-down capability on the chart. Something like below:
Let me know if this is what you are looking for.
Hi @Lyle ,
Please change the format of the [Month ETA] column to "dd mmmm", and then set the X-axis of the bar chart to the categorical type.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI @Lyle ,
Have you got a date hierarchy on your bar chart?
If you have a date hirarchy then you can drll down to day level and show days on the x-axis. Something like below:
The other way could be just to move the day part from your date column on the x-axis if you don't need a drill-down capability on the chart. Something like below:
Let me know if this is what you are looking for.
Thanks @Pragati11 ! I changed to using the calendar hierarchy and it's working perfectly. Many thanks
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |