Forum Discussion

An's avatar
An
Regular Visitor
5 years ago
Solved

ISSUE :  Format fields in the matrix visual based on the blank values.

ISSUE :  Format fields in the matrix visual based on the blank values.   I want to format the fields of matrix visual to RED when, the current month's value is BLANK and previous month's value is N...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    See attached - this becomes much more complex as you cannot provide computed conditional formatting to something that isn't there,

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

It is possible with the matrix visual but you need to create measures for that .

 

Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good) and show the expected outcome.

  • An's avatar
    An
    Regular Visitor
    5 years ago

    Hi,  

     

    I try again to post my message.   Yesterday it went wrong.

     

    This is the input table

     

    VendorLine itemPeriodAmount...
    MSFTL00521100 
    MSFTL00523100 
    PXSL00012100 
    TELL00083100 

     

    Expected outcome

     

     123TOTAL

    MSFT

    - L0052

    100

    100

    ☹️

    ☹️

    100

    100

    200

    200

    PXS

    - L0001

    ☹️

    ☹️

    100

    100

    ☹️

    ☹️

    100

    100

    TEL

    - L0008

    ☹️

    ☹️

     

    100

    100

    100

    100

     

    Instead of colouring my field in RED, I have added a smiley. 

     

    Kind regards

     

    An

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      5 years ago

      Here is a simplistic "solution".  For a proper solution you need measures.  When you say "month"  do you mean "period"  ?

       

      • An's avatar
        An
        Regular Visitor
        5 years ago

        Hi, 

         

        Not totally what I expected.

         

        Kind regards

         

        An