Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
Anonymous
Not applicable

How to make a segmentation data data filter with data in datetime format?

Hi! I'm from Brazil and totally new to Power BI, so sorry in advance for any English mistakes or innacurate terminology. I hope I am able to make you understand the problem I'm facing. 

I am trying to add a segmentation data filter to my dashboard, like this one:

 

The segmentation data visual I need to add to my dashboardThe segmentation data visual I need to add to my dashboard

 

I have a main fact table containig data from a set of telephone calls, from the project I'm working on. One of its columns is called 'data_hora', which contains the date and hour the calls were made in datetime format (dd/mm/yyyy hh:nn). It looks like this:

 

What the data_hora column looks likeWhat the data_hora column looks like

 

I need to make the segmentation data filter look like this, so the user is able to select both date and time:

 

Sem título.jpg

 

However, when I try to add this visual and drop the data_hora column to the data field, selecting the style 'Between', the time information never shows up in the filter:

 

'data_hora' colum added to the data field of the data segmentation field'data_hora' colum added to the data field of the data segmentation field

Segmentation configuration > Options > Styles > 'Between' (Entre)Segmentation configuration > Options > Styles > 'Between' (Entre)

 

What do I need to do in order to make the time information also be selectable along with the date?

1 REPLY 1
lbendlin
Super User
Super User

"Between Times"  is not possible with  slicers. Use the Filter Pane instead.

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.