Forum Discussion

Frixel's avatar
Frixel
Post Prodigy
5 years ago
Solved

How make a colored button?

Hello all,   I have a problem to make a button/shape or something that can change when the data give a Orange/Green (Started/Finished) instuction in the .csv data file when it is updated like here ...
Need Help
  • HashamNiaz's avatar
    HashamNiaz
    5 years ago

    Hi Frixel !

     

    You need to remove Last ')' paranthesis in your DAX formula.

     

    Regards,

    Hasham

Frixel's avatar
Frixel
Post Prodigy
5 years ago

Hi HashamNiaz 

 

Oke, i think i understand it but i can`t choise 'the latest" by the filter.

Can i then also the new messure connect to a shape for color changing?

HashamNiaz's avatar
HashamNiaz
Solution Sage
5 years ago

Hi Frixel !

 

You can creat a Latest Status measur eusing following DAX;

 

LatestStatus = 
  VAR _LastDate = CALCULATE(MAX(AccountStatus[DateTime]), ALLEXCEPT(AccountStatus, AccountStatus[Account]))
RETURN
    CALCULATE(MAX(AccountStatus[Status]),  FILTER(AccountStatus, AccountStatus[DateTime] = _LastDate))

 

You can replace AccountStatus as your Table name & respectively choose the column name.

 

Regards,

Hasham

  • Frixel's avatar
    Frixel
    Post Prodigy
    5 years ago

    Hi HashamNiaz 

     

    When i changed it then i have this error.

    I filter in the report on Today so what i wil see is then the latest "Time"

     

    • HashamNiaz's avatar
      HashamNiaz
      Solution Sage
      5 years ago

      Hi Frixel !

       

      You need to remove Last ')' paranthesis in your DAX formula.

       

      Regards,

      Hasham

      • Frixel's avatar
        Frixel
        Post Prodigy
        5 years ago

        Thanks HashamNiaz  the last ')' was the issue.

         

        Now i have this result but that is based on the 'Table' is it possible to 'connect' it with or as a visual like a button or shape?

        When i choise a shape then i don`t have the options of the fields for the shape.

        How do i do that?