Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter a report using query string parameters in the URL with single select slicer

Hi there   I have a PowerBI dashboard (connection: Analysis Services) embedded in a web and we want to build URL to pass down parameters into PowerBI - so when users filter something in the web and...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    hi d_gosbell 

     

    thanks for the reply, after several attempts, I found the workaround to use Hierarchy Slicer from marketplace and make it as Singel Select. It works, just the drawback is we can't have the slicer in the format of dropdown list, but still it helps ğŸ˜‰

d_gosbell's avatar
d_gosbell
Super User
5 years ago

Unfortunately there is no easy fix for this.

 

Url filters do not change slicers, they work by adding a report level (all pages) filter.

 

So when you change your slicer to a single select you are forced to save your report with a default value selected (eg L! Location = Location A). Then when you apply a url filter it adds a new "all pages" filter in the filter pane and if you select L1 Location = 'Location B' for example you now have the scenario where the filter condition is now  L1 Location = 'Location A' AND L1 Location = 'Location B' which filters out all your data.

 

At the moment you cannot use single select slicers with URL filters.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Is there an update to this, I want to be able to select a value from a slicer but not filter the whole report. Thanks.