I need to show "TOP 10" Postal Areas based on Sales for the selected date in Power BI.
I've used "Clustered column chart" and have also sorted the data based on Sales but the problem is it shows all the data sorted in descending order which is useless. I want to show only the first 10 bars (for TOP 10 Areas) and not all.
Thanks in advance.
So, as far as I understand, you have a separate table for the areas (postal areas).
In order to show only the top 10 areas by Sales, you need to create a new measure on the areas (postal areas) table and use the RANKX function (let's call the measure "Rank").
RANKX should operate on your table of postal areas, it should consider the Sales expression (I guess you have a Sales measure), and it should set the order to descending.
After that, you have to include the Rank measure as a visual filter in your column chart, and set to it to be "less than or equal to 10".
Let me know what you've achieved. :)
