Font Color Calculation groups

[ahmedshalabyy12]

Hello,

if i want to change the font color in my calculation groups how i can do this , i addded icons using dax but don't know how to change the font color 

Thank you 

[MFelix · Accepted solution]

Hi @ahmedshalabyy12 ,

Check if this videos can help you sort the options you need:

[v-hashadapu · Accepted solution]

Hi @ahmedshalabyy12 , Thank you for reaching out to the Microsoft Community Forum.

To change the font colour in your calculation group output in Power BI, you can’t do it directly within the calculation group itself. Power BI doesn’t currently support font colour formatting through DAX in calculation groups, even with the latest updates under Microsoft Fabric as of June 2025.

Instead, create a separate DAX measure that returns a colour name or hex code based on your logic, like red for negative values, green for positive, etc. Then, in your matrix visual, apply conditional formatting to the target field by selecting Font colour -> Format by field value and pointing it to your new colour measure.

This is the only supported way to dynamically control font colour in visuals that use calculation groups. Icons can remain in your calculation group logic using UNICHAR, but the colour must always come from a field-based format rule at the visual level.

Conditional Formatting in Power BI

 If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[v-hashadapu · Accepted solution]

Hi @ahmedshalabyy12 , Thank you for reaching out to the Microsoft Community Forum.

Thanks for the clarification and for sharing the image. You're correct, Power BI doesn't currently support applying font colour conditional formatting directly to fields from calculation groups in visuals like Matrix or Table.

While you can embed icon logic within a calculation group using DAX (like with UNICHAR), font colour formatting still relies on the "format by field value" approach, which unfortunately isn't supported for calculation groups at this time.

Since this is a known limitation, I'd recommend submitting your use case to the Microsoft Fabric Ideas and getting as many upvotes as possible. It's a good way to help influence future updates. In the meantime, where possible, you might consider applying the font colour logic on standard measures outside of the calculation group.

If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[v-hashadapu · Accepted solution]

Hi @ahmedshalabyy12 , Thank you for reaching out to the Microsoft Community Forum.

To change the font colour in your calculation group output in Power BI, you can’t do it directly within the calculation group itself. Power BI doesn’t currently support font colour formatting through DAX in calculation groups, even with the latest updates under Microsoft Fabric as of June 2025.

Instead, create a separate DAX measure that returns a colour name or hex code based on your logic, like red for negative values, green for positive, etc. Then, in your matrix visual, apply conditional formatting to the target field by selecting Font colour -> Format by field value and pointing it to your new colour measure.

This is the only supported way to dynamically control font colour in visuals that use calculation groups. Icons can remain in your calculation group logic using UNICHAR, but the colour must always come from a field-based format rule at the visual level.

Conditional Formatting in Power BI

 If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[ahmedshalabyy12]

This will not work because there's no option in conditional formatting for calc groups 
but thank you for your response 

[MFelix · Accepted solution]

Hi @ahmedshalabyy12 ,

Check if this videos can help you sort the options you need: