Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to 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
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
amazing! thanks!
please help! thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |