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 selimovd 

Yes i have found that article and have make this.
But how make i that when Finished the Started not more visible is?

 

HashamNiaz's avatar
HashamNiaz
Solution Sage
5 years ago

Hi Frixel !

 

There are multiple ways to solve this, You can create a measure to get teh latest status and you can only populate latets status based on that measure.

 

You create another flag measure which can be used to hide/unhide card visuals based on status.

 

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"