topic Re: conditional format in Custom Visuals Development Discussion

conditional format

khisla — Sun, 09 Feb 2025 10:16:59 GMT

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.

Thanks in advance

Re: conditional format

Fowmy — Sun, 09 Feb 2025 10:55:04 GMT

@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

Re: conditional format

khisla — Sun, 09 Feb 2025 19:27:01 GMT

Thanks you so much. The solution worked.

Re: conditional format

khisla — Wed, 21 May 2025 09:59:51 GMT

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.