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

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Frixel ,

 

you can use the conditional formatting to change the background of that rolumn based on the value. This would then also dynamically adapt. Check out the following article on how to that:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color-by-color-values

 

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

 

Best regards

Denis

 

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

  • 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?