Forum Discussion
Help with TOP N bar chart
Friends, how are you? I need help with a bar chart with top N.
The graph shows me the "general" topN, but it doesn't show me the top "N" specific to each selected category. (If you do it with the table above the chart, which has the same information and filters)
Could you help me so that when selecting a category from the left table it shows the specific top5?
Hi, Syndicate_Admin ;
Since you choose the cross-highlight in the picture; Unlike the slicer filter, it refers to the highlighting, the selected will be highlighted, but the selected will not be hidden, as in this article.
Filters and highlighting in Power BI reports - Power BI | Microsoft Learn
so if you want to output the right chart ,you must use slicer .
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi, Syndicate_Admin ;
Sorry I can't reproduce the data and a bit don't understand the results you want.
Can you provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples.? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Syndicate_Admin , if you have created TOPN with allselected, it should take filter
example
CALCULATE( [Sales] ,TOPN(3,allselected('Table'[Category]),[Sales],DESC),values('Table'[Category]))
refer
TOPN: https://youtu.be/QIVEFp-QiOk
https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/
https://drive.google.com/drive/folders/1aBFaQClcLZo2SKhbX_a1mZdltQReFKT3
I couldn't fix it with the option. Sample PBI attachment.
What I need is for the behavior of my chart to be like the one in the table on the right.
Hi, Syndicate_Admin ;
Since you choose the cross-highlight in the picture; Unlike the slicer filter, it refers to the highlighting, the selected will be highlighted, but the selected will not be hidden, as in this article.
Filters and highlighting in Power BI reports - Power BI | Microsoft Learn
so if you want to output the right chart ,you must use slicer .
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thank you very much, I had seen that using segmentation the graph worked correctly for me, but I thought that maybe there was another solution.
Best regards!!
