Is it possible to use Dynamic format string to change the font color in Calculation group?

[Tiger_an]

Hi everyone,

I want to use Dynamic format string to change the font color in Calculation group, seached  a lot on the internet, but without good luck, anybody has suggestion for this?

Thanks in advance!

[Tiger_an]

Hi Yilong, 

Thanks for your reply, I also leared that this is not possible. While I learned a workaround, which is using conditional formating with a based measure, which can realize my requirment, thanks again for your response.

[v-yilong-msft · Accepted solution]

Hi @Tiger_an ,

As I know, dynamic format strings primarily focus on formatting numerical data types and do not directly support changing font colors.  The functionality is designed to conditionally apply numeric and date formats based on the context of the data being displayed. This includes specifying different number formats, currency symbols, and date formats, but does not extend to visual styling attributes such as font color. This blog may let you know more about it: Creating Value Dynamic Formatting using Calculatio... - Microsoft Fabric Community

If you want to change the font color in the Calculation group, I think you can change the font color directly in Format visual in Visualizations.

Best Regards

Yilong Zhou

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