Date Slicer Format

[EVEAdmin]

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?

[123abc · Accepted solution]

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.

[sanjeewauom]

Hi @EVEAdmin 

Do you get the same formatting "dd/mm/yyyy" when published to service also.

because I cannot change to "dd/mm/yyyy" without change all language settings and even the users browser language

[anmolmalviya05]

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

[123abc · Accepted solution]

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.

[EVEAdmin]

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 · Accepted solution]

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