Forum Discussion

ermak's avatar
ermak
Frequent Visitor
6 years ago
Solved

Conditional formatting in tables

Hello! Can I configure conditional formatting so that the criterion is the previous value of the parameter? For example, in the report on positions in the search engine, I need to show whether the p...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi ermak 

     

    You can create a measure like below and use it for conditional formating in your matrix

    _arrows = 
VAR _previous = CALCULATE( SUM( 'Table'[Value] ), PREVIOUSDAY( 'Table'[Date] ) )
VAR _current = SUM( 'Table'[Value] )
RETURN SWITCH( 
    TRUE(),
    _previous = BLANK(), BLANK(),
    _previous < _current, 1,
    _previous = _current, 2,
    _previous > _current, 3
)

    I've attached a file with the solution as well.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi ermak 

 

You can create a measure like below and use it for conditional formating in your matrix

_arrows = 
VAR _previous = CALCULATE( SUM( 'Table'[Value] ), PREVIOUSDAY( 'Table'[Date] ) )
VAR _current = SUM( 'Table'[Value] )
RETURN SWITCH( 
    TRUE(),
    _previous = BLANK(), BLANK(),
    _previous < _current, 1,
    _previous = _current, 2,
    _previous > _current, 3
)

I've attached a file with the solution as well.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

 

  • ermak's avatar
    ermak
    Frequent Visitor
    6 years ago

    Hello, Mariusz !

    Thank you very much, but it only works if the dates are in order, for example 01.02.2020, 02.02.2020, 03.02.2020, etc. But it doesn't work if the dates are spaced, for example, 01.02.2020, 13.02.2020, 28.02.2020.

     

    Is there any way to fix this?