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?

Why is your report made in service? What does your data look like? What is the big picture? You are able to download pbix file for some reports, so this could help you create the needed measures, but it depends on your data source. If you're looking for help specific to Power BI Service, try posting your question in that forum specifically and provide more detailed information on the fact that you're creating report from Service and cannot use desktop solutions. That should help you get better responses the first time.

Frixel You use Conditional Formatting of the Button Text show ON or OFF based on a measure If you are satisfied with my answer, please mark it as a solution so others can easily find it.Don't forget to give KUDOS to replies that help answer your questionsSubscribe to ExcelFort: Learn Power BI, Power Query and Excel

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=TYLKDPcvgK8https://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-columnhttps://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

Frixel I have replied to your other topic, looks like you need to sign in/update credentials to get it working.For this topic, can you please provide more detail on the data you want to have connect to the button and why? Maybe we can help or provide an alternative idea.

Hi Fowmy my report is made in the service version and you cannot use measure there.How can I get that button in the service version?

One button with text ON or OFF | Microsoft Fabric Community

11 Replies

Fowmy
Super User
6 years ago
Frixel

You use Conditional Formatting of the Button Text show ON or OFF based on a measure

If you are satisfied with my answer, please mark it as a solution so others can easily find it.
Don't forget to give KUDOS to replies that help answer your questions

Subscribe to ExcelFort: Learn Power BI, Power Query and Excel
- Frixel
  Post Prodigy
  6 years ago
  Hi Fowmy
  
  my report is made in the service version and you cannot use measure there.
  How can I get that button in the service version?
  - AllisonKennedy
    Community Champion
    6 years ago
    Why is your report made in service? What does your data look like? What is the big picture? You are able to download pbix file for some reports, so this could help you create the needed measures, but it depends on your data source.
    
    If you're looking for help specific to Power BI Service, try posting your question in that forum specifically and provide more detailed information on the fact that you're creating report from Service and cannot use desktop solutions.
    
    That should help you get better responses the first time.
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
  Post Prodigy
  6 years ago
  Hi amitchandak
  
  But that is all for in the desktop version. I want it in het online version.
Icey
Community Support
6 years ago
Hi Frixel ,

How about using Bookmarks?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

One button with text ON or OFF

11 Replies

Related content

Button

Buttons

Button Slicer - Label text colors not working?

Adding Text to Power BI Shape or Button

Dynamic Button text changes