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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Super User
Super User

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.