Conditional formatting table rows

[Pedro_Lourenco]

Hi,

I'm working on the table below.

This table is showing the last quantity registered of the products in the storage by year/month/week or day (according to the drill-down ).

The Visual Value space is filled with this measure:

Last quantity registred= CALCULATE(SUM([Quant.]; LASTDATE ([date]))

As you can see, I'm trying to put some conditional format to indicate when the quantity increased ou decreased in comparison to the column on its left but I did not figure out yet...

Someone can help me, please?

EDIT**

Here is a .pbi file for an example

https://1drv.ms/u/s!Al373jcLzQYn8E9VlQR5Tns3pSqI?e=cgoLfp

[v-lid-msft]

Hi @Pedro_Lourenco ,

We can use the following steps to meet your requirement.

1. Create an icon measure,

Icon Set Measure = 
VAR difference =
    VAR sum__ =
        VAR cdate =
            MAX ( 'Table'[Date] )
        VAR pdate =
            CALCULATE (
                MAX ( 'Table'[Date] ),
                FILTER ( ALL ( 'Table' ), 'Table'[Date] < cdate )
            )
        RETURN
            CALCULATE (
                SUM ( 'Table'[Quant] ),
                FILTER ( ALL ( 'Table' ), 'Table'[Date] = pdate )
            )
    VAR sum_Q =
        CALCULATE ( SUM ( 'Table'[Quant] ) )
    RETURN
        sum_Q - sum__
RETURN
SWITCH ( TRUE (), difference < 0, -1, difference > 0, 1, 0 )

 2. Then we can configure the [Last quantity registred]’s icon based on [Icon Set Measure],

3. At last we can get the result like this,

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

BTW, pbix as attached.

Best regards,

[Pedro_Lourenco]

I Edited the post and inserted a pbix file so It could be easy to understand.

Basically I want to conditional formating based on the difference of the numbers in the columns by product, even when I drill up or down to see different time periods.

[VijayP]

The Question is not much clear. I can see the trend if the left column is high current column showing red and vice a versa

Request you to eloberate the problem statement