cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to format date in Chiclet Slicer to display as dd Mmm YYYY

I have aChiclet Slicer that has a date field WeekCommencingDate as the Category. It displays the date values as m/d/yyyy. How can I make the date display as d Mmm YYYY? That means for 7 December 2020, I want it to display as "7 Dec 2020"

 

5 REPLIES 5
v-zhenbw-msft
Community Support
Community Support

Hi @Anonymous ,

 

Sorry for that Power BI cannot change the slicer display with live connection model.

Because we can only create measure in this model, and the slicer category doesn’t support measure. It supports the real column.

 

H1.jpg

 

We can just format the date in table visual or other visuals.

 

H2.jpg

 

So the solution is to create a new format Date column in the SSAS.

Please refer this article,

http://cloudbi.com.au/date-custom-format-in-ssas-tabular/

 

If you have any question, please kindly ask here and we will try to resolve it.

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

In SSAS, it is not possible to format a date column as "dd Mmm YYYY". That is not one of the options. 

I find this very hard to understand. This is a stock-standard date display issue. That one of Microsoft's flagship product does not allow something so basic beggars belief.

Hi @Anonymous ,

 

Please refer this post, it maybe help to create a date format column in SSAS.

 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/014caf8e-04ed-4959-810a-894181afccab/i-need-to-create-a-custom-date-format-in-microsoft-tabular-model-ssas-2012-vs2010-can-somone?forum=sqlanalysisservices

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Anonymous , have you tried by setting up the format

Data Format New Rib.png

 

 

or refer: https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines
Anonymous
Not applicable

The format for this field cannot be set from the Format menu, because this Power BI report points to an SSAS tabular model as the source.

 

This image shows the options I have when I click on the field in the Chiclet Slicer, then select the Format menu in the Power BI report.

 

EylesIT_0-1595608839513.png

 

And this image shows the options when I click on the Modelling tab. All formatting options are greyed out.

 

EylesIT_0-1595609013498.png

 

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.