Forum Discussion
Top N for Parameter Selection
Hi,
I wanted to show top 3 in a chart for only one selection value in Parameter .
I created a parameter :
If i select Subcategory in parameter selection it should show only top 3 subcategory
If I select Category it show all categories . It should All Categories .I don't want Top 3 for Category Selection .
Is it possible to achieve it in Power BI ?
DATA :
| Category | Sub Category | Quantity Q2 | country | Created date |
| Furniture | Chairs | 10 | China | 22/05/204 |
| Furniture | Tables | 20 | China | 23/05/2025 |
| Automobile | Cars | 30 | China | 21/01/2025 |
| Automobile | Bikes | 40 | China | 21/03/2025 |
| Furniture | Chairs | 13 | India | 21/01/2025 |
| Furniture | Tables | 22 | India | 21/02/2025 |
| Automobile | Cars | 54 | India | 21/01/2025 |
| Automobile | Bikes | 60 | India | 30/01/2025 |
| Furniture | Chairs | 30 | China | 22/01/2025 |
| Furniture | Tables | 29 | China | 23/05/2025 |
| Automobile | Cars | 88 | China | 21/03/2025 |
| Automobile | Bikes | 22 | China | 21/04/2025 |
| Furniture | Chairs | 21 | India | 12/1/2025 |
| Furniture | Tables | 33 | India | 12/1/2025 |
| Automobile | Cars | 54 | India | 21/01/2025 |
| Automobile | Bikes | 60 | India | 30/01/2025 |
| Furniture | Chairs | 30 | China | 22/01/2025 |
| Furniture | Tables | 29 | China | 23/05/2025 |
| Furniture | Sofa | 88 | China | 21/03/2025 |
| Furniture | Bed | 22 | China | 21/04/2025 |
| Furniture | Dining | 21 | India | 12/1/2025 |
| Furniture | Tables | 33 | India | 12/1/2025 |
| Furniture | Tables | 54 | India | 21/01/2025 |
| Furniture | Sofa | 60 | India | 30/01/2025 |
| Automobile | Cars | 54 | India | 21/04/2025 |
| Automobile | Bikes | 60 | India | 30/06/2025 |
| Furniture | Chairs | 30 | China | 22/07/2025 |
| Furniture | Tables | 29 | China | 23/07/2025 |
| Furniture | Sofa | 88 | China | 21/03/2025 |
| Furniture | Bed | 22 | China | 21/04/2025 |
| Furniture | Dining | 21 | India | 12/1/2025 |
| Furniture | Tables | 33 | India | 12/11/2024 |
| Furniture | Tables | 54 | India | 12/10/2024 |
| Furniture | Sofa | 60 | India | 12/11/2024 |
Hi nish18_1990,
Please find the attached pbix file with solution.
Top N for Parameter Selection.pbixIf this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!
Best Regards,
Maruthi
4 Replies
Hi nish18_1990,
Please find the attached pbix file with solution.
Top N for Parameter Selection.pbixIf this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!
Best Regards,
Maruthi
Thanks it worked .
Category Sub Category Quantity Q2 country Furniture Chairs 10 China Furniture Tables 20 China Automobile Cars 30 China Automobile Bikes 40 China Furniture Chairs 13 India Furniture Tables 22 India Automobile Cars 54 India Automobile Bikes 60 India Furniture Chairs 30 China Furniture Tables 29 China Automobile Cars 88 China Automobile Bikes 22 China Furniture Chairs 21 India Furniture Tables 33 India Automobile Cars 54 India Automobile Bikes 60 India Furniture Chairs 30 China Furniture Tables 29 China Furniture Sofa 88 China Furniture Bed 22 China Furniture Dining 21 India Furniture Tables 33 India Furniture Tables 54 India Furniture Sofa 60 India Automobile Cars 54 India Automobile Bikes 60 India Furniture Chairs 30 China Furniture Tables 29 China Furniture Sofa 88 China Furniture Bed 22 China Furniture Dining 21 India Furniture Tables 33 India Furniture Tables 54 India Furniture Sofa 60 India
