topic Re: Formatting specific parts of a DAX in DAX Commands and Tips

Formatting specific parts of a DAX

dret — Tue, 29 Mar 2022 04:21:16 GMT

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!

Re: Formatting specific parts of a DAX

amitchandak — Tue, 29 Mar 2022 05:11:25 GMT

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"

Re: Formatting specific parts of a DAX

dret — Tue, 29 Mar 2022 15:01:48 GMT

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

Re: Formatting specific parts of a DAX

Anonymous — Fri, 01 Apr 2022 07:50:14 GMT

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.