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.
Hey,
I am wondering if anybody knows how to make a Date Hierarchy continue to weeks of Hours, or how to conect them.
I have a line and stacked colum chart with data:
If I use the Date EndUtc as EndUtc and no Date Hierarchy it works fine, but when I change to Date Hierarchy as above and drill down to days, for the last year I get stacked, the hours for every 1st day, it sums the first day of January, february etc, how can I make it so I see for every day for the last year and a line to drag? Maximum hours a day should be 24 h, here it is operational hours 50 hours a day for example, also I want to be able to drill down to hours as well. And same there if I add a Hour column and just drag it there, it also sums up for every hour for what filter is used, last week last month etcetera..
Please ask if I have to provide more information, if it was understandable or not.
Thanks!
Kind regards
Agnes
Solved! Go to Solution.
Hi @Anonymous,
You should click the third drill down button instead of the second one.
Best regards,
Yuliana Gu
Hi @Anonymous,
You should click the third drill down button instead of the second one.
Best regards,
Yuliana Gu
Here is an example of how I want it:
The second picture is how mine looks: doesn't conect to what month:
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 | |
95 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |