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

[Anonymous]

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"

[v-zhenbw-msft]

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.

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

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]

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.

[v-zhenbw-msft]

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]

@Anonymous , have you tried by setting up the format

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

[Anonymous]

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.

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