cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abdulkader
Frequent Visitor

power bi top 10 filltered with other chart

Dear All,

 

i'm tring to design power bi desktop report to buplish on web services , my report has a chart show top10 sales person , the chart show the top 10 for all category , my task is make this top 10 related to other chart also so i want to when the user select sales area the sales person chart provide the top10 for this sales area only , if the user select one branch the sales person chart provide the top10 for this branch only,could anyone help me to make this task.

 

 

Best Regards.

1 ACCEPTED SOLUTION

Hi,

 

I have written a measure to get your desired result.  However, with any visual other than a simple Table, the result is incorrect.  The moment i change the visual to a Table, i can see the Top 10 Salespersons appearing for any selection i make.   Please refer to the file here.

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

11 REPLIES 11
emadrigal
Helper II
Helper II

have you tried applying the top filter to each visualization?

hello,

 

i made the top10 for only this sales person chart on visual level filter , once i tried to make the same filter on other level or other chart i did not see the option topN .

 

 

Regards.

each visual have and advance filter where to can change it to the top n.

hello,

 

i think you did not get my point,

let me elaporate my report , we have 3 chart on my sales report  ,

1-sales person by net sales

2-region sales by net sales

3-branches by net sales

 

the sales person chart show top 10 sales person on all region and branches my request is .... once the user select spicific region or sales branch the sales person chart show only top 10 sales person for this region or sales branch.

 

 

Best Regards.

 

 

 

Regards.

Hi,

 

In the Filter/slicer, if a user selects a specific region and/or sales branch, then in the visual filter for the sale person chart, one should be able to see TopN.

 

Share your file for more specific help.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Dea Sir,

 

please download my file via below link.

 

 

https://we.tl/ztgRCv487d

 

 

Regards.

Hi @abdulkader,

 

I have downloaded the file.  Where do you need my help.  Please explain clearly.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

hello,

 

 

i want to filter the sales person from other chart , ex once you select region you will get top 10 sales person on this region only ,

once you select area manager you will face top 10 sales person for this area manager only .

 

 

Regards.

 

 

 

 

Hi,

 

I have written a measure to get your desired result.  However, with any visual other than a simple Table, the result is incorrect.  The moment i change the visual to a Table, i can see the Top 10 Salespersons appearing for any selection i make.   Please refer to the file here.

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Many Thanks Mr. Ashish Mathur ,

 

 

Best Regards.

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.