Can't apply dynamic formatting for measure DAX

[Iurii]

Hello everyone,

Could someone assist with the issue that dynamic formatting can't be applied anymore. Me and my collegues have tried to aplly it but when I put DAX formula inside of formula bar and click enter, nothing happens. It's weird because few months ago it worked well.
Before

After appliyng

Kindly support with the issue
Thanks in advance

[fjjpeeters1976]

Hi, I have a similar problem, I have a report that is a composite model using direct query and import mode. I have created some measures and I want to use dynamic formatting for it, however in the dropdown menu for the format it does not give me the option to select "dynamic".

I looked in the global settings but seems dynamic formatting is no longer a preview feature so it should be readily available.

anyone an idea what could be the issue?

Frank

[Anonymous]

Hi, @Iurii 

I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li

[Anonymous · Accepted solution]

Hi, @Iurii 

First, make sure you have set the dynamic format for your measure:

Select the corresponding format:

Note that if you are using live connection mode, we cannot apply dynamic conditional formatting:

Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

If you need to use it, switch the model to import/DirectQuery mode or write the corresponding metrics on the AS side.

Best Regards

Jianpeng Li

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

[FarhanJeelani]

Hi @Iurii ,

This can be frustrating, especially when you're confident the DAX formula is correct, yet nothing happens after you apply it.

One of the first things to consider is whether there have been changes to your Power BI environment. Updates to Power BI Desktop or the service might sometimes affect how certain features behave. If you haven't already, try updating Power BI Desktop to the latest version. Features like dynamic formatting can occasionally experience bugs that get patched in newer updates.

Another thing that could be causing the issue is a potential conflict in how the formatting is applied. If you're using a SWITCH statement, as shown in your screenshot, it should work fine for dynamic results. However, sometimes the format settings in the "Model" view or regional settings can interfere. You might want to double-check those settings to ensure nothing is overriding your formatting logic.

Also, remember that dynamic formatting works best in environments that support it fully. If you're working with specific visualizations or data models that have unique constraints, it might be worth reviewing the compatibility of the measure you're applying this to.

If none of these steps work, it might be a temporary glitch. Restarting Power BI or even creating a new measure with the same logic can sometimes bypass unexplained issues. Let me know if you're still stuck, and we can dig deeper into your formula or setup!

Please mark this as solution if it helps you. Appreciate Kudos.