Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 :
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?
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.
@Anonymous 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.