topic Re: Conditional formatting on part of cell in DAX Commands and Tips

Conditional formatting on part of cell

MathieuF — Fri, 20 Oct 2023 12:40:55 GMT

Good morning,
In a table, I use concatenation to group 3 values in the same cell.
I would like to be able to change the color of just one of the 3 values based on it.
How to do ?
Thanks in advance.
Mathieu

DAX:

DeltaSat (Formatage) =

FORMAT([DeltaSat (Agent)],"Percent") &

" | " & FORMAT([DeltaSat (Equipe)],"Percent") &

" | " & FORMAT([DeltaSat (Compétence)],"Percent")

Re: Conditional formatting on part of cell

_elbpower — Fri, 20 Oct 2023 13:28:03 GMT

Assuming you want to change the color of the value from [DeltaSat (Agent)] based on a condition, you can use the following DAX code:

DeltaSat (Formatage) = VAR AgentColor = IF([DeltaSat (Agent)] < 0.2, "Red", "Black") -- Define your condition here VAR AgentText = FORMAT([DeltaSat (Agent)], "Percent") VAR EquipeText = FORMAT([DeltaSat (Equipe)], "Percent") VAR CompétenceText = FORMAT([DeltaSat (Compétence)], "Percent") RETURN SWITCH( TRUE(), [DeltaSat (Agent)] < 0.2, "<span style='color:" & AgentColor & "'>" & AgentText & "</span> | " & EquipeText & " | " & CompétenceText, TRUE(), AgentText & " | " & EquipeText & " | " & CompétenceText )

In this code, we first define a variable AgentColor that checks a condition for [DeltaSat (Agent)] and sets the color to "Red" if the condition is met, otherwise "Black". You can change the condition as per your requirement.

Then, we use the SWITCH function to conditionally format the text in the DeltaSat (Formatage) column. If the condition is met, it wraps the [DeltaSat (Agent)] value in an HTML span element with the specified color.

Make sure you replace the condition in IF with your specific criteria for changing the color, and adjust the color and formatting as needed. This code assumes that you are working with a table that can interpret HTML styling for text color.

Re: Conditional formatting on part of cell

MathieuF — Fri, 20 Oct 2023 13:35:55 GMT

Hello _elbpower
Thanks for your return.
Are you sure the HTML code works in DAX, I tested it, but without success?

Mathieu

Re: Conditional formatting on part of cell

_elbpower — Fri, 20 Oct 2023 15:19:28 GMT

can you please share your measure code here

Re: Conditional formatting on part of cell

MathieuF — Fri, 20 Oct 2023 15:32:54 GMT

Here is what I did to test :

DeltaSat (Formatage) =

"<span style='color:red'>" & FORMAT([DeltaSat (Agent)],"Percent") & "</span>"&

" | " & FORMAT([DeltaSat (Equipe)],"Percent") &

" | " & FORMAT([DeltaSat (Compétence)],"Percent")

Re: Conditional formatting on part of cell

_elbpower — Sat, 21 Oct 2023 08:27:36 GMT

You can use a HTML visual and watch this video:

UpVote the idea here

Re: Conditional formatting on part of cell

MathieuF — Wed, 25 Oct 2023 07:20:42 GMT

_elbpower It's super complicated 😄

Re: Conditional formatting on part of cell

MathieuF — Wed, 25 Oct 2023 07:45:51 GMT

_elbpower

I am testing the 2nd solution

Re: Conditional formatting on part of cell

_elbpower — Thu, 02 Nov 2023 15:52:34 GMT

Use Tabulator PowerBI Visual
You can use this table in your report and just create a HTML measure like i have sent above. This is working fine,

Re: Conditional formatting on part of cell

MathieuF — Mon, 06 Nov 2023 10:57:22 GMT

Solved: Re: Create Table - Microsoft Fabric Community