Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I made below circle by unichar(9898) and unichar(9899) in card visual, however, i would like to make it be a specific color, like blue. I have tried to use the conditional formatting but it seems that it does not work. Each row in my data view have unichar(9898) and unichar(9899) already
Solved! Go to Solution.
Hi @Hayoung
I think I get what you are asking... I used UNICHAR(11044) to create circle and change font color.
1) Create a column 'Circle'.
Circle = UNICHAR(11044)
2) Create another column (font color) to determine the color of the circle based on the condition, for example: here I m trying to determine color based on the ID value.
font color = SWITCH(
TRUE(),
'Table'[ID] = 0, "#D9291C",
'Table'[ID]= 1, "#ED8B00",
'Table'[ID] = 2, "#FFCD00",
'Table'[ID] = 3, "#A0DCFF",
'Table'[ID] = 4, "#6FC2B4",
'Table'[ID] = 5, "#C4D600",
"#046A38"
)
3) Then use the "font color" column in card/any visual i.e.using font color option and select the function in the Color category. Then choose "Field value" in format style and "first font color" in the below option. Pasted below the screenshot for reference.
4) Click OK 🙂 and you will be able to see the below color card visual
This should work for you as well...
Thanks,
AnthonyJoseph
Hi @Hayoung
I think I get what you are asking... I used UNICHAR(11044) to create circle and change font color.
1) Create a column 'Circle'.
Circle = UNICHAR(11044)
2) Create another column (font color) to determine the color of the circle based on the condition, for example: here I m trying to determine color based on the ID value.
font color = SWITCH(
TRUE(),
'Table'[ID] = 0, "#D9291C",
'Table'[ID]= 1, "#ED8B00",
'Table'[ID] = 2, "#FFCD00",
'Table'[ID] = 3, "#A0DCFF",
'Table'[ID] = 4, "#6FC2B4",
'Table'[ID] = 5, "#C4D600",
"#046A38"
)
3) Then use the "font color" column in card/any visual i.e.using font color option and select the function in the Color category. Then choose "Field value" in format style and "first font color" in the below option. Pasted below the screenshot for reference.
4) Click OK 🙂 and you will be able to see the below color card visual
This should work for you as well...
Thanks,
AnthonyJoseph
Hi @Hayoung
If in case you would want to view as table, then you can use conditional formatting option in the circle column so that the output looks like:
Also you can use any HEX color value (that I have included in the calculated column-"font color" ).
Hope this helps!
Thanks,
AnthonyJoseph
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |