Forum Discussion

jakubalbrecht's avatar
jakubalbrecht
Helper I
2 years ago

Merge URL parameters filters and predefined filters

Hello,   1. I can predefine filters in Power BI reports so that readers of the Power BI report in online Power BI service evironment can then filter the report using those filters, they cannot use ...
Need Help
jakubalbrecht's avatar
jakubalbrecht
Helper I
2 years ago

Hello Anonymous ,

 

thank you very much but there is still no progress on my side.

 

https://app.powerbi.com/groups/...../reports/.....&filter=Languages%2FLanguage%20in%20(%27en%27)

 

still duplicit filter is created - in my original report and ever the same on a brand new report when only a single table Languages has been created with a single column Language to avoid interferencing with other data:

 

 

I really do not understand why your and mine result is different while sharing the same approach. Power BI URL filtering seems not to be an excellent piece of work by Microsoft.

 

Any other idea how to solve it?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi jakubalbrecht ,

     

    Is it possible to consider hard-coding the original filter to the Dax measure? If so, please refer to the following steps:

    1. For the original report, we need to clear the filter on 'Languages' [Language]:

     

    2. then please create a new pbix. here we need a dimLanguages table:

     

    3. then create a new measure like:

     

     

    Report URL = 
// You need to replace the base url with the actual URL of your own report
VAR __base_url = "https://app.powerbi.com/groups/5562e085-51a1-4c99-aa4f-6ab2a5351adc/reports/80805289-a9e0-4de2-b4a6-5c34167faa03/"
// Here we assume the original filter was 'cs' before
VAR __filter1 = "?filter=Languages/Language in ('cs','"
VAR __filter2 = CONCATENATEX('DimLanguages','DimLanguages'[Language],"','")
VAR __result = __base_url & __filter1 & __filter2 & "')"
RETURN
__result

     

    Here setting the data category as WebUrl

     

    4. Do some landscaping. Here I'm assuming the original filter was 'cs' and I've hidden the 'cs' option in the slicer. Then created a button and bound the previously created measure. It looks like this now:

     

     

     

    5. Publish. When we select the slicer, the measure automatically generates a link to the report containing the URL filter:


    Clicking the button will automatically jump to the report:

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group