how to show date and time both in same slicer in power bi

[krishna_murthy]

Hi Team,

i came cross the requirement to show the date and time (30/06/2025 15:12:36)  in power bi slicer as like below , refer the below screenshot for your references 

Currently showing below is the format and along with date i need to show time . please check and share me the details 

[v-tejrama · Accepted solution]

Hi @krishna_murthy ,

Thanks for checking and sharing those details. Since your SQL column is already a valid DateTime field, the behavior you’re seeing is expected. The built-in Power BI slicer can filter data accurately at both the date and time level, but it only displays the date portion in the visual. At the moment, there’s no native option to make the slicer show the time text alongside the date. This is a known design limitation of the default slicer rather than an issue with your data.

The custom visuals you mentioned, such as Smart Filter Pro and Date/Time Slicer, were useful alternatives in the past but are now either limited in functionality or not fully supported in some environments. Time Brush is no longer available on AppSource, which is why you couldn’t locate it.

If your goal is to both display and filter by date and time together, the most reliable approach in DirectQuery mode is to handle the formatting directly in your SQL source. You can create a new column in your SQL view or query that formats the datetime field to show both date and time for display purposes, while keeping the original datetime field untouched for filtering in Power BI. This way, the formatted field can be used for visual display, and the native datetime field can power the slicer to filter data precisely down to the second.

This setup ensures your filters continue to work correctly with DirectQuery, gives you a clear date and time display in your visuals, and avoids any dependency on unsupported visuals or Power BI limitations.

Thank you.

[Kedar_Pande]

Create a calculated column that combines date and time:

DateTime = 'Table'[Date] + 'Table'[Time]

 

Use this new column in your slicer. Format it to show both date and time in the slicer visual's formatting options.

[krishna_murthy]

@Kedar_Pande  Thanks for update 

here the error getting refer the below screenshot 

[v-tejrama]

Hi @krishna_murthy ,

You’re absolutely right that Power BI’s default slicer doesn’t display both date and time together, even when your field includes the time portion. By design, the native slicer focuses on the date part for simplicity, so even if your column is a true DateTime type, the visual often only shows the date. Since your model is using DirectQuery, that also explains why creating a calculated column with a DAX expression like FORMAT didn’t work, as DirectQuery restricts those kinds of transformations and treats formatted outputs as text, which prevents time-based filtering.

The good news is that you can still achieve what you need without converting or recreating columns. If your SQL field is already a proper datetime or datetime2 column, keep it as is and use a Between slicer on that same field in Power BI. The Between slicer fully supports datetime filtering, so you can pick precise timestamps when selecting ranges. Even if the visual doesn’t show the time text in the label, the filter will still apply to the exact time values in your data.

If you specifically want both the date and time displayed together, the built-in slicer doesn’t support that format. In that case, it’s best to use a custom visual such as Smart Filter Pro, Date/Time Slicer, or Time Brush from AppSource. These visuals can show both date and time clearly and still work properly in DirectQuery mode. If you ever decide to switch to Import mode, you could also format the datetime display in the column formatting settings within Power BI rather than using DAX, which keeps it recognized as a true DateTime field.

This approach ensures your slicer remains fully functional, filters data accurately by both date and time, and displays values in the format you expect without running into DirectQuery limitations.

Thank you,
Tejaswi.

[krishna_murthy]

@v-tejrama ... Thanks for quick support 

i have verfied the thoughly but here the details 

1. SQL field have already a proper Date/Time format but slicer not showing
2. Smart Filter Pro & Date/Time Slicer, : This is not working 
3.Time Brush--- Unable to find and not found 

[v-tejrama · Accepted solution]

Hi @krishna_murthy ,

Thanks for checking and sharing those details. Since your SQL column is already a valid DateTime field, the behavior you’re seeing is expected. The built-in Power BI slicer can filter data accurately at both the date and time level, but it only displays the date portion in the visual. At the moment, there’s no native option to make the slicer show the time text alongside the date. This is a known design limitation of the default slicer rather than an issue with your data.

The custom visuals you mentioned, such as Smart Filter Pro and Date/Time Slicer, were useful alternatives in the past but are now either limited in functionality or not fully supported in some environments. Time Brush is no longer available on AppSource, which is why you couldn’t locate it.

If your goal is to both display and filter by date and time together, the most reliable approach in DirectQuery mode is to handle the formatting directly in your SQL source. You can create a new column in your SQL view or query that formats the datetime field to show both date and time for display purposes, while keeping the original datetime field untouched for filtering in Power BI. This way, the formatted field can be used for visual display, and the native datetime field can power the slicer to filter data precisely down to the second.

This setup ensures your filters continue to work correctly with DirectQuery, gives you a clear date and time display in your visuals, and avoids any dependency on unsupported visuals or Power BI limitations.

Thank you.

[v-tejrama · Accepted solution]

Hi @krishna_murthy ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.

[krishna_murthy]

@rohit1991  i have tried power query same thing i have added slicer but not showing time ,,, and tried DAX for cacluated column but not picking those column names. 

one more point is i have connected to direclty query from SQL.
please check other way to do make it 

[rohit1991]

Hi @krishna_murthy 

Hi @krishna_murthy,

If your slicer is not showing time even though it’s coming from SQL, it’s because Power BI is treating that column as Date instead of Date/Time.

Could you please try below steps:

1. In Power Query, check that your column (for example, system_order_time) is set to Date/Time type - not just Date.
2. Close and apply >> refresh the model.
3. Use a Between slicer with that same Date/Time column. It will now show both date and time.
4. If you’re in DirectQuery mode and still can’t see the time:
   • Create a computed column in SQL like this:
   • Then reload the data and use that field in your slicer.

CONVERT(varchar(20), system_order_time, 103) + ' ' + CONVERT(varchar(8), system_order_time, 108)

[rohit1991]

Hi @krishna_murthy 

In Power BI, the default date slicer only shows the date part, even if your column has a time value. To display both date and time together (like 30/06/2025 15:12:36), you need to make sure your field is properly set up as a Date/Time type and used in the right way.

Could you please try below steps:

1. In Power Query, check your column type, it must be Date/Time, not just Date.
2. Load the data again into Power BI.
3. Add a Between slicer visual and use that same Date/Time field.
4. In the slicer, Power BI will now show both date and time together.
5. If it still shows only the date, create a new column using DAX:

         DateTime_Display = FORMAT('Table'[IST_system_order_time], "dd/MM/yyyy HH:mm:ss")​

         Then use this column in your slicer, it will display both date and time clearly.