Formatting specific parts of a DAX

[dret]

Hi there,

I'm looking for a way to format a Card to show the number highlighted in red below (974) in a different color than the rest of the text. What I'd like is for the 1 finding off non-compliance for every ... items examined to be a lighter grey so the number pops.

Not sure how I can achieve this, and would love some help 🙂

Text Value for Error Per = 
"1 finding of non-compliance for every" &" "& CALCULATE(SUM('CalcTable'[Value]), 'CalcTable'[Category] IN { "Total Per" }) &" "& "items examined"

Thanks!

[Anonymous · Accepted solution]

Hi @dret ,

As a workaround, you could create three cards and then group them.

Reference: Use grouping in Power BI Desktop - Power BI | Microsoft Docs 

Best Regards,

Stephen Tao

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

[amitchandak]

@dret , Based on what I got you can use the format

Text Value for Error Per = 
"1 finding of non-compliance for every" &" "& format( CALCULATE(SUM('CalcTable'[Value]) , 'CalcTable'[Category] IN { "Total Per" }), "#,###") &" "& "items examined"

[dret]

Hi there,

Thanks for your help, I'm a little confused, what exactly is going in the #,### should it be a Hex? I tried that and it wasn't working, just returning this