Forum Discussion

Exel_Paul's avatar
Exel_Paul
New Member
8 years ago

Several Reports using the Same Customer Code

hi there   this is my first post to the forum.   i have several reports on my desktop, ie.  list of last 10 sales orders, list of last 10 quoations, pie chart of parts sold to a customer.   wha...
Exel_Paul's avatar
Exel_Paul
New Member
8 years ago

thanks

 

i need the report User to be able to select the customer code from say a drop down ( ala Filters in XLS)

 

does that make sense?

 

paul

stretcharm's avatar
stretcharm
Memorable Member
8 years ago

Yes it makes sense, but it's not possible if you have several powerbi documents.

 

However if all your reports are in a single powerbi on different tabs/pages you can use parameters

 

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

 

What is your source sql? If so you may need to use text manipulation of the SQL to apply the parameter filter

 

Also if you bring in all the data or use direct connect then you can just use slicers.

 

The latest version has syncing of slicers across different pages.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2018-feature-summary/