Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi PowerBI experts,
I am currently working with a dataset where each line represents information of a specific hour, and would like to plot such data grouped by days, weeks or months, given the users interest.
The grouping of the data is achieved by creating custom columns (DAY, WEEK and MONTH) and setting such columns as the X Axis of my plots. However, in this solution I am forced to have 3 different plots for each time slice, when the ideal solution would involve a slicer filter where I could select a time slice and the plot would update automatically.
Specifically, and function/trigger that could alter a plot's X Axis through a checkbox would work for me. Is this type of behavior supported by PowerBI?
Thanks in advance!
this works great except in cases where you add weekend date and quarter and the dates correspond with a month end for example.
Then you are not allowed to sort by the column because it does not have a unique value. any ideas?
the Datekey is joined to the date table but the time value order is what is being used to sort. you see it will not work as there is not a unique value.
Attribute | DateControl | DateKey | Value | Time Value Order |
Month | 1 | 8/1/2021 0:00 | 8/1/2021 | 5137 |
WeekEnd | 0 | 8/1/2021 0:00 | 8/1/2021 | 4935 |
Great post.
Are you sure there is no other way? like we used to do with MDX? by replacing sets?
Any work around for this, using DAX with SWITCH?
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |