Forum Discussion
Power Bi filter Context between 2 Pages
Hi Everyone I need some help
I have a dataset of various companies and have created a dashboard in Power BI. On the first page, I display information like company name, address, pincode, employee count, and other details. Each company has a unique ID, which allows me to search and view its details.
Now, on the second page, I want to show a list of nearby companies. For example, if the company code is "111" and the name is "ABC" with a pincode of "110020," I want to display all companies that share the same pincode ("110020"). Additionally, if I change the company code, the list of nearby companies should automatically update based on the new pincode.
You need to use the filter pane, disconnected tables, and measures as visual filters (in that order) to make this work.
A lot of effort for a questionable user experience. Did anyone of your users actually ask for this ?
Ntnk1999 if it is based on the same pin code from the main page then you can use drill thru page, and drill thru column will be pin code and turn off keep all filters
2 Replies
- lbendlinSuper User
You need to use the filter pane, disconnected tables, and measures as visual filters (in that order) to make this work.
A lot of effort for a questionable user experience. Did anyone of your users actually ask for this ?