How can i open customer details from a list of customer

[hellgoingon]

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?

[v-yulgu-msft · Accepted 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

[v-yulgu-msft · Accepted 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

[Sunkari · Accepted solution]

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

[hellgoingon]

That's so great! thanks

[prateekraina]

Hi @hellgoingon,

How many parameters do you intend to pass and what are those?
Ideally you should just pass CustomerID.

Prateek Raina

[hellgoingon]

At least 8 parameters because there are many tables in customer details. Example:

CustomerInfo table

DealerOfCustomer

TotalNewDealerOfCusotmerEachMonth

TotalSaleOfCustomerEachMonth

................................

[prateekraina]

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