Conditional Formatting on Cards by OKVIZ

[Anonymous]

I added multiple fields to a states by OKVIZ card. I'm ok the color of the other fields but i want the "SKUInventory and KPILight to change to specific colors based on three conditions wile the others remain fixed. I have a slicer that I will be using and that would make the values of Skuinventory  change, hence the KPILight should change as well. Thanks

Red color - 0 - 0.39
Yellow - 0.40 - 0.59
Green - 0.60 - 1.

[v-lili6-msft]

hi  @Anonymous 

I have tested on my side, it seems that it could not achieve conditional format just for part of fields in Cards by OKVIZ,

so as a workaround, I would suggest you use built-in Card visual for these two fields that you do conditional format for them, and then drag them beside of Cards by OKVIZ visual.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-card

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color-by-rules

Regards,

Lin

[amitchandak]

@Anonymous , this is custom visual, you have contact developer.

But in case conditional formatting is supported with "field" option you can create a measure and use that

Colour = 
SWITCH(TRUE(),
Table[Date] < TODAY(), "red",
Table[Date] = TODAY(), "orange",
"green")

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK(Table[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Anonymous]

Hi @Anonymous 

If you change the values of Skuinventory, will it not affect the other calculations as in your chart.

I believe your answer lies in your question.

[lbendlin]

What did the creators of the OKVIZ Cards visual reply when you brought it up with them?

[Anonymous]

@lbendlin 

I'm not sure how to reach out to them.

[v-lili6-msft]

hi @Anonymous 

Here is their website that you could reach out to them.

https://okviz.com/card-with-states/

Regards,

Lin