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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
khisla
Frequent Visitor

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
Frequent Visitor

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
Frequent Visitor

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors
Top Kudoed Authors