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 under.

 

So i think there is a green button/shape for row 1 and 2 because station004 gives back it is Finished (Green is the latest update)

And a button for row 3 station002 is the button/shape Orange because the file gives back that it is started (Orange is the latest update)

 

How can i make something that the color is change if the data is changed?

 

 

Need Help
  • HashamNiaz's avatar
    HashamNiaz
    5 years ago

    Hi Frixel !

     

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

     

    Regards,

    Hasham

11 Replies

  • 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

  • HashamNiaz's avatar
    HashamNiaz
    Solution Sage
    5 years ago

    Hi Frixel !

     

    You can set the Button background property or Fill color property set the property to be based on conditional formatting & set the Fomrat by to Field Value and provid ethe color column.

     

    Regards,

    Hasham