Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric certified for FREE! Don't miss your chance! Learn more
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:
Result, showing "Oc" instead of "Oct":
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:
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.