cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
April90
Frequent Visitor

Query string creates separate filter on the same column

I have 2 filters table_names and aggregation_date. Users can select them based on their need. User access reports by searching from the directory of App. this is how their filter panel looks:

 

Screen Shot 2020-01-15 at 5.23.56 PM.png

 

 

I also send reports to some users with pre-selected filters (using query string). The users who access the report using the query string link see two filters for the same columns, which is confusing. Is there is a way to have just one of them? 

 

Screen Shot 2020-01-15 at 5.16.47 PM.png

 

 

2 REPLIES 2
Microsoft v-gizhi-msft
Microsoft

Re: Query string creates separate filter on the same column

Hi,

 

After my test, it works well here. 

The filter will not change after sharing with others, please check whether you added a new filter for same field before sharing.

 

Best Regards,

Giotto Zhi

April90
Frequent Visitor

Re: Query string creates separate filter on the same column

Hi, 

 

Thanks for looking at my question 🙂  Answering to your question, I double-checked, it is the same report and I have not added another visual filter.

 

This is how I share with a query string and it creates a separate filter for table_names and set it. I was expecting it to use the existing table_names filter. 

 

report_link?filter=daily_time_series_data/table_names eq 'action__2_0'

 

Note: I have a check that both the filters come from the same table and same column. 

 

Just adding more details, both the filters show the same value. However, the existing filter shows 'All' label. Which is very confusing

for end-user. Here are expanded and collapsed filters screenshot.

 

It works, but the user experience is suffering. Thanks for helping here 🙂 

 

Screen Shot 2020-01-16 at 10.06.33 AM.pngScreen Shot 2020-01-16 at 10.08.03 AM.png 

 

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors