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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
EVEAdmin
Post Patron
Post Patron

Date Slicer Format

Hi all

In one of my reports, I am using the Slicer visual to filter dates. The slicer style is set to BETWEEN. 
I would like to format the visual, so the 2 date cells are centered. But I can't locate any setting. Am I missing it?
Is there an option to centre those 2 cells, please?

EVEAdmin_0-1732264375645.png

 

2 ACCEPTED SOLUTIONS
123abc
Community Champion
Community Champion

In Power BI, there isn't a direct option to center-align the date fields within a slicer visual when using the "Between" slicer style. However, you can adjust the overall appearance of the slicer to achieve a more balanced look:

Workarounds:

  1. Resize the Slicer Visual:

    • Drag the borders of the slicer to make the visual more symmetrical. This can make the date fields appear more centered visually.
  2. Add a Border or Background:

    • Use a background color or border to align the visual contextually. This won't center the fields but can create the illusion of better alignment.
  3. Use a Custom Date Picker:

    • Instead of the default slicer, consider using a custom visual from the Power BI marketplace, such as Smart Filter Pro, which might offer more formatting options.
  4. Switch to a List Format:

    • If centering is critical, consider changing the slicer to a dropdown or list format, which might offer better alignment options.

Unfortunately, the Power BI slicer in "Between" mode does not yet have advanced customization for individual input box alignment. If this is a frequent requirement, you can suggest the feature to Microsoft through their Power BI Ideas page.

View solution in original post

123abc
Community Champion
Community Champion

If this help you to solve your issue please mark it as solution sofar otehr people use it as a solution.

View solution in original post

4 REPLIES 4
anmolmalviya05
Memorable Member
Memorable Member

Hi @EVEAdmin, You can try to reduce the width of the visual to make it center align with respect to title

123abc
Community Champion
Community Champion

In Power BI, there isn't a direct option to center-align the date fields within a slicer visual when using the "Between" slicer style. However, you can adjust the overall appearance of the slicer to achieve a more balanced look:

Workarounds:

  1. Resize the Slicer Visual:

    • Drag the borders of the slicer to make the visual more symmetrical. This can make the date fields appear more centered visually.
  2. Add a Border or Background:

    • Use a background color or border to align the visual contextually. This won't center the fields but can create the illusion of better alignment.
  3. Use a Custom Date Picker:

    • Instead of the default slicer, consider using a custom visual from the Power BI marketplace, such as Smart Filter Pro, which might offer more formatting options.
  4. Switch to a List Format:

    • If centering is critical, consider changing the slicer to a dropdown or list format, which might offer better alignment options.

Unfortunately, the Power BI slicer in "Between" mode does not yet have advanced customization for individual input box alignment. If this is a frequent requirement, you can suggest the feature to Microsoft through their Power BI Ideas page.

Thank you @123abc 
Now I know I am not missing a setting, somewhere.
I increased the values font size, so now it is centered. 
Thank you again. 

123abc
Community Champion
Community Champion

If this help you to solve your issue please mark it as solution sofar otehr people use it as a solution.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.