Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Help with URL Filters (Special Characters?)

Hello,   I'm having trouble implementing a url filter and I'm wondering if anyone can help me figure out what I've done wrong.   Here's the url/query parameters:   [url]?filter=SLA_x0020_Query/...
Need Help
v-xicai's avatar
v-xicai
Community Support
5 years ago

Hi Anonymous ,

 

You may try:

 

[url]?filter=SLA_0020_Query/Bldg._0020_Region eq 'NorAm West' and SLA_0020_Query/Bldg._0020_Region eq 'NorAm East'

For reference:

 

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

 

https://stackoverflow.com/questions/54667067/power-bi-embedded-parameter-space-in-column-name

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for your reply Amy,

 

I tried your attempt but it did not work. I think the period after Bldg is a problem, so I also tried changing that, no dice. Additionally, I don't think your logical statement returns the desired result (if it worked). I want to include data points from East and West. There are no data points that are both East and West. Perhaps or would work.

 

Attempt below:

  • skolbe's avatar
    skolbe
    New Member
    1 year ago

    Did you ever find a resolution? I have a column with a period in the name that I want to use in a URL filter and I'm having trouble with it as well. I don't own the report so I can't change the column name.