filter in URL not working

[pwferguson99]

I have the following tables in my power bi model:

ParentTable(parentid varchar(20))

ChildTable(childid varchar(20))

ParentChildTable(parented varchar(20), childid varchar(20)) (FK to both Parent and Child table)

ChildDetail1Table (childid varchar(20), other stuff)  (FK to Child table)

ChildDetail1Table (childid varchar(20) other stuff) (FK to Child table)

Slicer with ChildName – from childtable

BarChart1 has data from ChildDetail1Table

Table2 has data from ChildDetail2Table

I’m trying to use the ‘?filter= ParentTable/parentid eq ‘xxxx’ ‘ in the url to show the children associated with a specific parent

Is this even doable since I do not have the parentid in any of the visuals? what returns is all children with no filtering - which coincides with the way it looked before publishing

I have also tried changing the filter to ?filter= ChildTable/childid in ('xxxx','yyyy','zzzz') - before and after adding the childid to a visualization

I have followed every video and document I can find but am unable to make this work.  Any guidance would be greatly appreciated.  

[Anonymous · Accepted solution]

Hi, @pwferguson99 

First we need to put a field on Filter on this page before publishing

After publishing, we open the report on the service and append http to the URL, and need to delete experience=power-bi

Then here is my preview:

For more information, please refer to the following document:

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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

[pwferguson99]

Thank you. I added an additional slicer for the parentid and then hid it(because the requirement indicated that it was not to be visible) and it worked.  I guess I thought PBI would be able to read the semantic model/relationships and identify the correct children