Forum Discussion
URL Filter> update existing filter
Hi d_gosbell ,
thank you for the hint with HASONEFILTER. Based on your solution I did some research an found this: https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/
I settled for a combination of your solution and the one suggested in the link. Now I can get rid of my default filer and use URL based filtering.
whereismydata wrote:
I either need to update the existing or delete/ignore the existing filter.
I'm not aware of any way of doing this, the url filters are designed to add to any existing saved filters.
One alternate approach is do the check for a location filter in your measures rather than by setting a default filter. So if you save your dashboard with no locations filtered, then wrap all of your measures in an expression like the following:
IF ( HASONEFILTER( table[LocationName] ) , <your measure expression> )
This will achieve the same result of displaying blank until the user selects a single location and then your url filter will work as you will not have to save the fake "please choose a location' record as the default filter