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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Dynamic formatting of date measure

Dynamic formatting of measures that return a date is not possible.

When creating a measure that returns a date, it is not possible to enable the dynamic format, while there are several use-cases where this would be relevant.

 

Then, I tricked PowerBi into enabling dynamic formatting by first creating a numerical measure then setting formatting to dynamic and setting the format string, and then changing the measure to the actual measure, it results in weird behaviour:

Format string:

Rolf_Vermeer_1-1758022202063.png

 

Result, showing "Oc" instead of "Oct":

Rolf_Vermeer_0-1758022122496.png

However, if I keep the date to a numeric value (so measure: "TEST = 1* MIN(SalesOrders[ShipmentDate])", the behaviour is even more unexpected, the same dates as above then result in this:

Rolf_Vermeer_2-1758022514223.png

 

So clearly, dynamic formatting in such cases does not work as expected while it would solve several issues.

 

(Note: I'm aware that this example could be achieved in much easier ways, but the actual use-case is more complex, but not so relevant for this idea)

Status: New