Column Bar chart filtered by Top N Values in Power BI Paginated Report.

[db2907]

Let's supposed I have this dataset:

If I order it by Value (Z->A), I get this:

If I create a column chart based on the Top 6 Values, I'm getting the right result:

But if I try to do the same with the Area, I'm getting all the Values in the chart:

This is the configuration for the category group:

What do I need to change in order to reach the expected result, just the 6 first values represented in the column chart by area.

This would be result that we need: The top 6 values (aggregared) represented in their respective areas, without modifying the original dataset, only throught the configuration of the visualization :

[d_gosbell]

I don't understand what you are expecting here. There are only 3 areas in your data, so when you ask for a top 6 you get all 3 areas since there are not more than 6 areas. What behaviour are you expecting?

[db2907]

Hi, @d_gosbell  thanks for your reply. I have updated the post. The idea is to see only the top 6 values represented in the column chart (by area), but without touching the original dataset, just using the configuration of the visual. The dataset is used in other visuals. 

[d_gosbell]

---

@db2907 wrote:

The idea is to see only the top 6 values represented in the column chart (by area), but without touching the original dataset, just using the configuration of the visual. The dataset is used in other visuals. 

---

So you cannot do this just using the group configuration. There is no way to alter the order of the grouping and filtering in the chart configuration.

I think your only option is to create a second copy of the dataset, do your top N filtering there. Or an even better approach would be to do the Top N in the query for that second dataset so it's done at the source rather than in the reporting layer. Then you can build both your charts off that new dataset.