filtering using url
4 TopicsDax code to combine bookmarks
Hi y'all, I have a button, which when a selection is chosen from the primary slicer, and then the button is pressed on, takes me to a URL link attached, now, I want to write a dax for the button such that, Power Bi checks if the URL link actually exists or not, if it exists, it takes me to the link, if not, then my bookmark (which is a pop-up window) gets activated and shows up. I would appreciate any tips and suggestions with this. Thank you so much. Sincerely, ME827Views0likes2CommentsURL Filter> update existing filter
Hi, this seem to be something very trivial but I do not find a solution to this: My report shows data for several locations. When a user opens the report I want the visuals to be empty. Therefore I created a record with the location name 'please choose location' and set the location filter to this record. This all works fine. Also I automatically want to send out mails to user if there is something wrong in their location. In this mail, I want to filter down the report to the exact location with this link for example: https://domain/reports/powerbi/Dashboard?filter=table%2FlocationName%20eq%20%27Location1%27 Now, this works. But my problem is, that the filteritem is duplicated and therefore nothing is show since both filters are applied. I either need to update the existing or delete/ignore the existing filter. Maybe someone can help me. Thank you!Solved3.8KViews0likes3CommentsURL FIlter is not workin in Power BI Report Server
Hi all, I am trying to filter my PBIRS report but it's not working. I am using the syntax ?filter=table/field eq 'value'. It looks like it is understanding the syntax, but it's not passing the value. It's returning the field I am trying to filtering with a caution sign and filtering is(all). PBRIS is on premise, I was wondering if that's why it is not working? Cheers!!Solved10KViews0likes8CommentsFiltering Power BI Report Server Report With URL Parameters When Table or Column Has Space
I have created a basic report to test this scenario. My report has a table called Employees and this table has a column named FirstName. I can successfully filter the report using url parameter e.g. filter=Employees/FirstName eq 'John' This works fine. The Employees table also has a column 'Last Name' and when I attempt to filter it using the same method, the report is failing to recognize the field. I am using the following syntax: filter=Employees/Last_x0020_Name eq 'Smith' I have tried this scenario on several reports and attached is how the filter appears in the report (unrecognized) . Does Power BI Report Server filtering not work with spaces in the fields?Solved1.2KViews0likes2Comments