Filter Time from 18:00 to 12:00 (next day)

[virus190]

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? 

Here is the .pbix

[virus190]

@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.

[Pragati11]

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:

https://community.powerbi.com/t5/Community-Blog/Advanced-Time-Line-Slicer-Sorting-data-by-shifts-up-...

Let me know if this is helpful.

Thanks,

Pragati

[Anonymous · Accepted solution]

Could you change the slicer to a list?

[amitchandak]

@virus190 , you need bucketing or you need one number?

[virus190]

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.

[richbenmintz]

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!

[Anonymous]

Try the following

Count of ID = 
CALCULATE(
	COUNTA('Tabellenblatt1'[ID]),
	'Tabellenblatt1'[Hour]
		IN { 7, 8, 9, 10, 11, 12, 18, 19, 20, 21 }
)

[virus190]

This would work, but i want it as a filter. 

18:00 - 12:00 was only an example. Sorry, didnt make it clear.