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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
RodrigoMenezes
New Member

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors