Forum Discussion
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 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?
1 Reply
- lbendlinSuper User
"Between Times" is not possible with slicers. Use the Filter Pane instead.