Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Conditional formatting not reflecting for all the rows wrt Periods of Actual and Masterplan

Hi all, 

 

Doubt with a measure

 

Wrote measure in such a way that, wrt Actuals it should display one colour, wrt Master plan it should display one colour based on Period selection in slicer

 

Kindly help me out in writing measure, enclosed image for reference of measure and matrix visual

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    In above measure, referenced one more measure that is Colour_Act & MP. But for all rows colour is not reflecting only for few rows it is reflecting

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi, 

       

      Okay

      As data changed individually wrt Act & MP we have hard coded the measure for replicating the values. 

      Now it's colour is happening wrt Actuals and Master Plan

       

      Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, 

    Sorry for late reply

     

    Yes it has come as of now hard coded the Measure. 

    As its a finance data, data will be keep on adding wrt each financial year

     

    So tried to write measure dynamically but it is not working. 

     

    Thank you