Date displaying differently after publication

This is a known behavior in Power BI Service: date slicers (especially dropdown ones) render differently than in Power BI Desktop. Specifically:

- In Power BI Desktop, the date format honors your model format or your system locale (dd mmm yyyy like 26 Mar 2025).
- In Power BI Service, dropdown slicers sometimes override that and display a long date format, like Wednesday, March 26, 2025, especially if the column is a DateTime or uses system locale defaults.

You need to force the desired format (dd mmm yyyy) across both Desktop and Service:

In Power BI Desktop, go to PQ editor, select your date column (Alt Fuel Bill date) and add a new column:

Alt Fuel Bill date (Formatted) = Date.ToText([Alt Fuel Bill date], "dd MMM yyyy")

Then use the new column in your slicer instead of the original date.

If you want to use DAX, you can create a new calculated column:

Formatted Date = FORMAT('YourTable'[Alt Fuel Bill date], "dd MMM yyyy")