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.
Hello everybody. What I'm trying to achieve is a chart showing the sunrise and sunset times change during the year. Something like you can see below. The dotted constant blue lines show "normal" activity time 6-22 and he blue line was my attempt to show total daylight. Please help.
Date | Sunrise | Sunset |
01/01/2023 | 07:42:58 | 15:35:51 |
02/01/2023 | 07:42:50 | 15:36:56 |
03/01/2023 | 07:42:38 | 15:38:03 |
04/01/2023 | 07:42:23 | 15:39:13 |
05/01/2023 | 07:42:05 | 15:40:25 |
06/01/2023 | 07:41:43 | 15:41:40 |
07/01/2023 | 07:41:18 | 15:42:57 |
08/01/2023 | 07:40:50 | 15:44:17 |
09/01/2023 | 07:40:19 | 15:45:39 |
10/01/2023 | 07:39:44 | 15:47:03 |
11/01/2023 | 07:39:06 | 15:48:29 |
I can't inslude the time (or datetime if I create it), because the chart tries to aggregate the field and I'm seeing nonsense. And I can't select "don't summarize"
You can plot the sunrise column and the sunset column together with the daylight time, but you need to make sure the data type matches for the daylight time and the sunrise/sunset time.
I can't plot it, because the chart tries to aggregate the field and I'm seeing nonsense.
Can you select "Don't Summarize"?
Nope.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |