cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

How can i open customer details from a list of customer

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?

2 ACCEPTED SOLUTIONS
Microsoft
Microsoft

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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/#

 

 

View solution in original post

6 REPLIES 6
Microsoft
Microsoft

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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/#

 

 

View solution in original post

That's so great! thanks

Memorable Member
Memorable Member

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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors