Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
i want a filter in my reporting that shows all the data that have been beetween 18:00 to 12:00 (next day).
I have a Column with Date & Time, i extracted the Hour from this column and using it as a filter.
Now if i want the number of ID's that are beetween 18:00 and 12:00 (next day) i have to do it in 2 steps and add the number. (1. From 18:00 to 21:00, 2. From 07:00 to 12:00)
Is there a solution to do it in one step?
Solved! Go to Solution.
@Anonymous ah why i didnt came up with this, so easy, but should work great.
A slicer would be a little bit nicer, then selecting/deselecting all values individually, i think.
@Pragati11 im gonna test this.
@richbenmintz i also like this one, i will test it. thanks.
Hi @virus190 ,
I tried to use Time Brush Slicer custom visual:
This sicer allows you to select a range of date-time values.
Additonal information on this can be found here:
Let me know if this is helpful.
Thanks,
Pragati
Could you change the slicer to a list?
@virus190 , you need bucketing or you need one number?
Sorry, but im not sure what bucketing means?
I want to be able to use a time filter for all visuals on the page, so in this case that the number of id's and the table will be filtered with a dynamice filter like the slice.
Hi @virus190,
What about something like
Measure =
var cur = CALCULATE(COUNTROWS(Tabellenblatt1), FILTER(ALLSELECTED('Tabellenblatt1'), ('Tabellenblatt1'[DATE] >= MIN('Tabellenblatt1'[DATE]) && 'Tabellenblatt1'[Hour] >=Min('Tabellenblatt1'[Hour]))))
var next = CALCULATE(COUNTROWS(Tabellenblatt1), FILTER(ALLSELECTED('Tabellenblatt1'), ('Tabellenblatt1'[DATE] <= max('Tabellenblatt1'[DATE]) && 'Tabellenblatt1'[Hour] <=Max('Tabellenblatt1'[Hour]))))
return
cur + next
Hope this Helps,
Richard
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
Proud to be a Super User!
Try the following
Count of ID =
CALCULATE(
COUNTA('Tabellenblatt1'[ID]),
'Tabellenblatt1'[Hour]
IN { 7, 8, 9, 10, 11, 12, 18, 19, 20, 21 }
)
This would work, but i want it as a filter.
18:00 - 12:00 was only an example. Sorry, didnt make it clear.
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |