Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have a report contain all customer and when clicking on a customer, detail of that customer will be displayed in another page
Example:
------------------------------------------------
Customer page
Customer ID Customer Name Details link
1 Customer A Detail link
2 Customer B Detail link
-------------------------------------------------
When clicking on "Detail link", detail info relate of that customer will be displayed in another page.
I intend to pass parameter via URL but i only can pass 1 parameter while there are many tables in detail page.
What can i do to overcome this trouble?
Solved! Go to Solution.
Hi @hellgoingon,
By default, it is allowed to pass only one filter with the query string. Agree with prateekraina, if you want to filter multiple tables via URL, the workaround is creating mapping relationship between all these tables you want to filter. If you want to filter data based on multiple fields which are contained by a single table, one way you could do this is by creating a calculated column that concatenates two fields to a single value. Then you could filter on that item. Reference: Filter a report with a URL query string parameter
Regards,
Yuliana Gu
We have multiple fields url support. Refer the below link for the same.
https://powerbi.microsoft.com/en-us/blog/power-bi-service-april-and-may-feature-summary/#
Hi @hellgoingon,
By default, it is allowed to pass only one filter with the query string. Agree with prateekraina, if you want to filter multiple tables via URL, the workaround is creating mapping relationship between all these tables you want to filter. If you want to filter data based on multiple fields which are contained by a single table, one way you could do this is by creating a calculated column that concatenates two fields to a single value. Then you could filter on that item. Reference: Filter a report with a URL query string parameter
Regards,
Yuliana Gu
We have multiple fields url support. Refer the below link for the same.
https://powerbi.microsoft.com/en-us/blog/power-bi-service-april-and-may-feature-summary/#
That's so great! thanks
Hi @hellgoingon,
How many parameters do you intend to pass and what are those?
Ideally you should just pass CustomerID.
Prateek Raina
At least 8 parameters because there are many tables in customer details. Example:
CustomerInfo table
DealerOfCustomer
TotalNewDealerOfCusotmerEachMonth
TotalSaleOfCustomerEachMonth
................................
Hi @hellgoingon,
Keep a CustomerDimension in detailed report and create relationship of all these tables with CustomerID.
Then in the URL use this CustomerDImension table to filter, it will filter all other tables as well.
Prateek Raina