Forum Discussion

Frixel's avatar
Frixel
Post Prodigy
6 years ago

One button with text ON or OFF

Hi all,   Is it possible to create one button in PoweBi that shows text ON or OFF depending on conditions 1 or 2 from a table. Must i then have a specially visualization?
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Frixel , Create a measure like this

Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) <today(),"On","Off")

 

Use this in any dynamic title or color formatting.

https://www.youtube.com/watch?v=TYLKDPcvgK8
https://www.blue-granite.com/blog/create-a-dynamic-title-in-power-bi-updated

 

 

or

 

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

  • Frixel's avatar
    Frixel
    Post Prodigy
    6 years ago

    Hi amitchandak 

     

    But that is all for in the desktop version. I want it in het online version.