Forum Discussion
Filter visual based on multiple criteria
Hi friends,
I'm trying to create a bar chart with sales volume by category. The values I want to present is the sales volume of a specific category and categories with top 3 sales volume. However, I don't know how to have these two filters simultanrous on one visusal.
Currently from the 'filter' option of the PowerBI, I'm able to dynamically filter Top 3 (top N filter type) or the specific catagory I want to present(basic/advanced filtering). May I ask if there's a way to keep both filters? Thanks!
Example:
From the table below, I want to present the sales volume of 'grocery' and the other 3 categories with the highest sales.
| Catagory | Sales Volume |
| appliance | 10,000 |
| baby | 15,000 |
| grocery | 80,000 |
| beauty | 30,000 |
| jewellery | 1,000 |
| clothing | 5,000 |
Bar chart I want to have:
Hi Anonymous ,
Please new a measure like:
Measure = VAR __top3 = TOPN(3,ALLSELECTED('Table'[Catagory]),CALCULATE(SUM('Table'[Sales Volume]))) VAR __result = IF(SELECTEDVALUE('Table'[Catagory])="grocery"||SELECTEDVALUE('Table'[Catagory]) IN __top3,1) RETURN __resultThen select the visual and configure the filter like this:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
3 Replies
Hi Anonymous ,
Please new a measure like:
Measure = VAR __top3 = TOPN(3,ALLSELECTED('Table'[Catagory]),CALCULATE(SUM('Table'[Sales Volume]))) VAR __result = IF(SELECTEDVALUE('Table'[Catagory])="grocery"||SELECTEDVALUE('Table'[Catagory]) IN __top3,1) RETURN __resultThen select the visual and configure the filter like this:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum