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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
khisla
Helper I
Helper I

conditional format

I have the below visual and want to create a conditional format

If the transactio No. is Transaction No +1 of the previous row (for difference store number) to have an icon with a red circle.

For example, in my below data transaction # 145571 + #145572 would have a red circle icon while the others would be green.

My data is filtered on currency therefore not sure if that would impact the conditional formating.

 

 

khisla_0-1739095976538.png

 

Thanks in advance

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@khisla 
Not sure if you need the solution as follows:

Flag = 
VAR __PrevTrxNo = 
    MAXX(
        OFFSET( 
            -1 ,
            SUMMARIZE(ALLSELECTED(Table01) , Table01[Store No.] , Table01[Transaction No.] ),         
            ORDERBY( Table01[Transaction No.]  )
        ),
        Table01[Transaction No.]
    )
VAR __CurrTrxNo = SELECTEDVALUE(Table01[Transaction No.])
VAR __Result = INT(__PrevTrxNo + 1 = __CurrTrxNo)
RETURN
    __Result

 

Fowmy_0-1739098497267.png

 



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

3 REPLIES 3
khisla
Helper I
Helper I

Quick question.

This solution worked however it is not marking the first item in the series.

For example the above transactions 145571 + 145572 are marked as red however not 145570.

How can I modify the formula so that 145570 will also be flagged as red.

 

khisla
Helper I
Helper I

Thanks you so much.  The solution worked.

 

Fowmy
Super User
Super User

@khisla 
Not sure if you need the solution as follows:

Flag = 
VAR __PrevTrxNo = 
    MAXX(
        OFFSET( 
            -1 ,
            SUMMARIZE(ALLSELECTED(Table01) , Table01[Store No.] , Table01[Transaction No.] ),         
            ORDERBY( Table01[Transaction No.]  )
        ),
        Table01[Transaction No.]
    )
VAR __CurrTrxNo = SELECTEDVALUE(Table01[Transaction No.])
VAR __Result = INT(__PrevTrxNo + 1 = __CurrTrxNo)
RETURN
    __Result

 

Fowmy_0-1739098497267.png

 



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors