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

RodrigoMenezes — Thu, 22 Feb 2024 17:13:17 GMT

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 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 like

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

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

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?

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

lbendlin — Thu, 22 Feb 2024 21:45:46 GMT

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

topic Re: How to make a segmentation data data filter with data in datetime format? in Custom Visuals Development Discussion

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

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