Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a clustered bar chart with a field of data type time on the X-axis. What I'd like to do is explicitly set the bounds of the axis from 00:00:00 to 23:23:59 so that the scale doesn't change as the user applies further filters. Is there a way to do this? The format options seem to require me to include a full datetime as my start and end parameters.
Solved! Go to Solution.
Thanks for the reply Dale, but the issue I had with that approach is that I get no data in my chart - presumably because the date part is missing from my time-only field.
In the end I was able to achieve what I wanted not by setting the bounds, but by selecting "Show items with no data" on the field I was charting.
Hi,
If you have a column which is just time (not datetime), you can try it. Though it isn't perfect, it works. Have a look at picture for details.
Best Regards!
Dale
Thanks for the reply Dale, but the issue I had with that approach is that I get no data in my chart - presumably because the date part is missing from my time-only field.
In the end I was able to achieve what I wanted not by setting the bounds, but by selecting "Show items with no data" on the field I was charting.
My pleasure. I am so glad you have solved you problem.
Best Regards!
Dale
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |