Button depends on data set connection ?

Question

Hi there,How to show the button as green when the dataset connected to the power bi is fine and refresh on scheduled event but show red when the data connection is not working ?sample model attached.https://1drv.ms/u/s!AhqwbtIVEKQ2bTEWC2x1Dug50Fs?e=P1cVNz&nbsp;

amitchandak · Answer

suvechha , you can create a card or MultiKPI and use conditional formatting to color background.
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

greg_deckler · Answer

suvechha&nbsp;- Is this Direct Query or Import mode?

v-deddai1-msft · Answer

Hi&nbsp;suvechha&nbsp;,&nbsp;I would suggest you to show last refresh time in your report:&nbsp;&nbsp;https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops&nbsp;If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.&nbsp;Best Regards,Dedmon Dai

Forum Discussion

Button depends on data set connection ?

3 Replies

Related content

Button

Circular dependency

View Items that depend on a Connection

Buttons

Dax query dependency