Forum Discussion
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 ...
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
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?
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
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"