- Data source: Monthly P&L, including revenue and costs.
- Use data to drive clustered bar chart.
- Filter by column 1 of data to summarise revenue streams (column 1 is a revenue / cost indicator).
- 12 revenue streams returned with Storage Dry as the highest revenue and Sundry Income as the lowest.
- Filter by column 2 of data to summarise top 5 revenue streams.
- 5 revenue streams returned in the chart, but rather than top five, 1st, 2nd, 6th, 10th and 12th ranking are reflected in the chart.
Been going around in circles for days and I get similar unexpected result when filtering for cost; I cannot understand where I am going wrong...
Could you upload your file, anonymized of course? Otherwise it will be difficult to help.
So I went back to the problem today:
To test the functionality and my understanding I made up a much smaller, simpler data set, applied it to the same clustered bar chart format in Power BI, then filtered by Top N / Bottom N - it worked first time giving results I expected.
I went back to the original Power BI model and applied the filter once more and it worked correctly. I have no idea how / why - I did exactly the same as I have been trying to do for the last week! Who knows how it might work going forward...
Thankyou Riny for your response and offer of help.
