Formatting of multiple rows with a simple DAX

nsamuel30 — Sun, 15 Mar 2020 07:23:47 GMT

In this scenario, lets say we have a simple table and we want to do formatting of consecutive rows with a specific color then with the help of index table and simple dax we can acheive this in a short time rather than formatting each and every row.

Let's say I only want background color for odd accounts like 100,300 and so on.

For this, just create a simple index table like this which is shown below

Use the account column from this table and use in the visual. Once this is done, we just to use simple dax to create a color column based the condition.

The dax which will be used is

Color = IF(Index_Table[Index]=1,1,IF(Index_Table[Index]=3,1,IF(Index_Table[Index]=5,1,IF(Index_Table[Index]=7,1))))

This will bring number 1 infront of odd number accounts.

For background color, all you have to do is select the color column for conditional conditional formatting.

Hope, this will help you in formatting for multiple rows in a short time.

Thanks,

Noel Samuel

topic Formatting of multiple rows with a simple DAX in DAX Commands and Tips

Formatting of multiple rows with a simple DAX