Is there any way to set the conditional formatting in a default way?

[william0076]

Hi,

I'm constantly having to change the conditional formatting for each metric within my Matrix Visual. Is there a setting i can use to change the below settings?

Current Default

Rules i want to set permanantly when i open up conditional formatting

Thanks!

Will

[amitchandak · Accepted solution]

@william0076 , I doubt I have seen a option like that to default.

But you can create a color measure and use that with field value option, That can be like fix.

You can use unichar and color measure for icon formatting

example

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"))

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

Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

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

Icon

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692