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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.