Power BI Desktop - Dynamic Formatting not an option on the drop down Lists

[Damian_6]

Hello, I've enabled Dynamic formatting in the Preview Features setting and restarted the program but it doesnt appear under the format drop down list in Column Tools or Measure Tools. (Power BI Desktop)

Also the Measure Tools tab doesnt show automatically when data is selected I have to go to the modeling tab and click new measure for it to appear. Once it does appear anything I click within the measure tools tab just makes it close down meaning it cannot be used.

I'm trying to change the values to show thoundands as K and Millions as M which I can see online how to do but dont have "Dynamic" as a format option to choose.

Any help would be greatly appreaciated.

Thanks

[Damian_6]

Thanks for this, It's odd as there are several videos online showing "Dynamic" as an option on the drop down so wierd it just force closes that tab when I click on format.

https://www.youtube.com/watch?v=ROyVkQ9vTjc&ab_channel=Curbal

I'll have a look at the Calculation group suggestion though thanks

[Shosher]

Sadly this is still in preview and might not work everywhere you'd want it to. 

A good solution for now is calculation groups for now, Use a switch statement that checks the length and build it yourself! or ask chat gpt nicely

https://learn.microsoft.com/en-us/power-bi/transform-model/calculation-groups 


Hope this helps!