One button with text ON or OFF

[Frixel]

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?

[Icey]

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.

[amitchandak]

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

[Frixel]

Hi @amitchandak 

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

[Fowmy]

@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]

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]

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]

Hi @AllisonKennedy ,

I don`t get it working as i make a report in desktop.

I have a .csv file in OneDrive what more times a hour is updated. Ik want that my report that see and also update in the OneDrive schedule. I get that only when i make the report in the service version and not in desktop.

See also this topic from me where somebody helps mee but not resolved.

I don`t no what i do wrong.

[AllisonKennedy]

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

[Frixel]

Hi @AllisonKennedy 

Sorry for the late response 😥

What I would like is a button or something like that when the status is "Started" the button is orange and when the status is "Finished" the button turns green.
The filters that the conditions have you see in the print screen.

I hope you understand what I mean.

[harshnathani]

Hi @Frixel ,

You can add buttons, but will not be able to write the measure for ON and OFF in  Power BI Service.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-buttons#:~:text=To%20create%20a%20b...

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[Fowmy]

@Frixel 

You cannot create measures in service, the only possibility I know so far is through PBI Desktop.

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