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

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?  

       

      • HashamNiaz's avatar
        HashamNiaz
        Solution Sage
        5 years ago

        Hi Frixel !

         

        You can place this measure on Card Visual and overlay a button image over it using selection pane.

         

        Regards,

        Hasham