topic Re: Putting a Time Value in slicer in DAX Commands and Tips

Putting a Time Value in slicer

sharpedogs — Fri, 28 Feb 2020 03:43:44 GMT

I'm not sure if it's something simply i am overlooking but i can't seem to add a slicer to a simply time value.

Below is a sample of my data set. I want to add a slicer so i can show products purchased between 8am and 5pm. When i put the below Time data in a slicer it looks odd (12/30/1899) (12/30/1899) as if it doesn't recognize the time as an actual time value. In PowerQ i've changed the type to Time, but then when i go to powerbi there is no icon beside the value. It's like i need to make another change to the column?

Product	Date	Time
A	Feb 27	08:50:01 PM
B	Feb 27	09:10:05 PM
C	Feb 27	10:12:10 PM

Re: Putting a Time Value in slicer

vivran22 — Fri, 28 Feb 2020 06:12:30 GMT

Hello sharpedogs

In the slicer, use it as List or Dropdown

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn

Re: Putting a Time Value in slicer

sharpedogs — Fri, 28 Feb 2020 15:11:03 GMT

Hey Vivran,

Using the drop down is sort of mybackup plan. But when you consider i get a new file dropped into the update folder every hour the dropdown box would get a little large, 24 drop downitems. The reson i was looking at a slider is so that the user could easily slide the time. If they wnated to see the CPU usage between 7am and 1pm. I guess they coudl simply click each box in the drop down.

The dropdown isn't terrible. I just think being able to do the slider would be a better user experience.

Re: Putting a Time Value in slicer

vivran22 — Mon, 02 Mar 2020 04:51:10 GMT

sharpedogs

May I suggest to create an additional column for hour? You can use Power Query or DAX for that and then use it as a slicer.

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn