Filter visual based on multiple criteria

[hpilearn]

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:

[Anonymous · Accepted solution]

Hi @hpilearn ,

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
__result

Then select the visual and configure the filter like this:

Best Regards,
Gao
Community Support Team

If 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

[hpilearn]

amazing! thanks!

[hpilearn]

please help! thanks!