Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Jwah
Frequent Visitor

Identify changing row values - alternating row colours grouping

Hi All

 

A user wants a table with some repeating information to display alternating background colours to show they belong to the same ID. 

 

Basically I want each row to check if the ID is the same as the previous row and if not, change colour for that row. Is there a way to use DAX to get a result of either a 1 or 0,  and then I can use conditional formatting with that. 

 

Example data:

Jwah_1-1632984044332.png


Desired:

Jwah_0-1632984009485.png

Apologies if this has been dealt with previously - I've spend some time searching these forums and i may not be using the correct search terms. I'm fairly new to DAX and it feels like i'm jumping into the deep end with this!

 

Jwah

 

 

 

1 ACCEPTED SOLUTION
Jwah
Frequent Visitor

Amazing that after posting this, the forum suggested this as a solution:

Solved: Re: Alternate row colour after 7 rows/after each n... - Microsoft Power BI Community

 

EvenOdd = IF(ISEVEN(RANKX(ALLSELECTED('Table'),CALCULATE(SELECTEDVALUE('Table'[ID])),,ASC,Dense)) = TRUE(),1,0)

 

 

View solution in original post

1 REPLY 1
Jwah
Frequent Visitor

Amazing that after posting this, the forum suggested this as a solution:

Solved: Re: Alternate row colour after 7 rows/after each n... - Microsoft Power BI Community

 

EvenOdd = IF(ISEVEN(RANKX(ALLSELECTED('Table'),CALCULATE(SELECTEDVALUE('Table'[ID])),,ASC,Dense)) = TRUE(),1,0)

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.