How To Add Reset Button In Power Bi

To add a reset button in Power BI, you can use a combination of measures and buttons. Here’s a step-by-step guide on how to do it:

1. Create a measure that will serve as a reset trigger. This measure could be a simple boolean flag or a numeric value that represents the reset state. For example, you can create a measure called “Reset Flag” with the formula: Reset Flag = 0.
2. Add a button visual to your Power BI report. You can find the button visual in the “Visualizations” pane. Place the button wherever you want it to appear on your report canvas.
3. Edit the properties of the button visual. You can do this by selecting the button and going to the “Button” section in the “Visualizations” pane.
4. In the “Button Text” field, enter the label you want to display on the button. For example, you can enter “Reset”.
5. In the “Action” section, select “Web URL”. This will allow us to trigger an action when the button is clicked.
6. In the “URL” field, enter the following DAX expression:
   https://app.powerbi.com/groups/me/reports/<>/ResetFlagValue?rs:clearSession=true
   Replace <> with the ID of your Power BI report. You can find the report ID in the URL when you are viewing the report in Power BI service.
7. Save the changes to the button visual.

Now, when you click on the button, it will trigger the URL action and reset the value of the “Reset Flag” measure to its default state. You can use this measure as a filter or a condition in your report visuals to reset their state.

Here’s an example to illustrate the usage:

• Create a table visual that displays your data.
• Add a filter to this visual based on the “Reset Flag” measure. Set it to include only the rows where the “Reset Flag” measure is equal to 1.
• Now, when you click on the reset button, it will set the “Reset Flag” measure to 0, and the table visual will update to show all rows.