topic Conditional formatting with DAX for all columns in DAX Commands and Tips

Conditional formatting with DAX for all columns

Mous007 — Mon, 20 Jul 2020 15:31:50 GMT

Hi all,

I am trying to conditionally format all the columns on my table. I can do each column manually but i am trying to be more efficient as i have more than 25 columns on my tables.

All the columns should have a background color based on the following rules:

1) Show red background color for any column cell with a value <> Blank OR value > 0

2) show green or no color background color for any color cell = Blank

A screen shot is also provided below.

Is there any possible way i can format all column at once without having to do it individually for each column please ?

Any leads/hints would be highly appreciated.

Best,

Mous

Re: Conditional formatting with DAX for all columns

amitchandak — Mon, 20 Jul 2020 16:39:28 GMT

Mous007 ,

Create a color measure like the give example

Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) <today(),"lightgreen","red") Color Date = var _min =minx(allselected(Date,Date[Year]) return Switch( true(), FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"lightgreen", FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"blue", "red") if(FIRSTNONBLANK(Table[Value],"true")= "true","green","red")

Use this with field option in color formatting of all the columns

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

Re: Conditional formatting with DAX for all columns

Anonymous — Tue, 21 Jul 2020 08:40:01 GMT

Sadly, for conditional formatting there is NO option to format all columns in one go. You have to go through them one by one. I know about it because I've done a similar research myself before.

Best
D

Re: Conditional formatting with DAX for all columns

Mous007 — Tue, 21 Jul 2020 16:16:26 GMT

Thank you guys.

Seems like some manual work is inevitable in this situation ...