Forum Discussion
Button resets all the runs
My power bi report has one reset and cancel button, it clears all the filter selections. App side user has to do a submission and he will receive a pbi report link (which consists a runID )via email while clicking on that link he can see his report in service. The problem
Is whenever i am testing while clicking on reset and cancel buttons it clears the filtering and shows all the data in all the runIDs. Say for example i have done 3 submissions and received 3 separate links but clicking on t
reset or cancel button shows all the 3 run's data. I want it to be like when i am clicking on the button it should clear only that specific runID data should not show the other two ID values. How to implement this ? I tried creating a measure to apply a visual level filter but no luck ! Please do the needful
Hi kichu123
I'm assuming you're using this URL filter method https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters to filter the report, and bookmarks for the reset button?
If that’s the case, when creating a bookmark, if you keep the tick mark on “All visuals”, it will also reset the URL filter. However, if you select each visual individually and use the “Selected visuals” option in the bookmark, it will not reset the URL filter on the page .
I’ve attached a sample — the button on the left uses the “All visuals” reset option, while the one on the right uses the “Selected visuals” reset option.
Thank you soo much !!! Its working now . 😇
5 Replies
- kushanNa
Super User
Hi kichu123
I'm assuming you're using this URL filter method https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters to filter the report, and bookmarks for the reset button?
If that’s the case, when creating a bookmark, if you keep the tick mark on “All visuals”, it will also reset the URL filter. However, if you select each visual individually and use the “Selected visuals” option in the bookmark, it will not reset the URL filter on the page .
I’ve attached a sample — the button on the left uses the “All visuals” reset option, while the one on the right uses the “Selected visuals” reset option.
Thank you soo much !!! Its working now . 😇
- rajendraongole1
Hi kichu123 - suggest you, Instead of relying on URL filtering alone, you can capture and preserve the RunID automatically.If your report already receives the RunID via URL, it’s available in your data model.
Eg:. create a measue as like: replace with your table name and so on .
ActiveRunFilter =
VAR SelectedRunID = SELECTEDVALUE('RunTable'[RunID])
RETURN
IF(
[RunID] = SelectedRunID,
1,
0
)apply this at visual level filter with 1. Hope this works.
DaleTResolver II
Hi,
"should not show the other two ID values.", is this related to the access permission? If so, you need to implement RLS in your semantic model. Becuase filters aren't an effective method of permission management. If not, applying a table level filter by the App or replacing the built-in RESET button with bookmarks button should be helpful.
I have already implemented rls on my emailid column with userprinciple (). Problem is for every submission user will receive urls with unique runIDs which is creating on every run. Once he opens the link he should only see the data related to that specific run. But when i click on reset or cancel buttons in the report it resets all the data so that he can see all the data related to every runids he has created so far!!
