Dynamic Top N slicer works with table, not with bar chart

[OLM]

Dynamic Top N slicer works with table, not with bar chart

Seeing I cannot expose the real data, I will present similar and simple example

Lets say I have a sales table with 1k sales across 5 product categories.

Now on the dashboard I present the top N per table visual (sales id, amount, product category) using the following guideline: 

1. Create TopN table using DAX: 5, 10,15

2. Create Rankx to ranks sales by amount

3. Create DisplayTopN measure

4. In table visual filter pane set DisplayTopN = 1

TopN dynamic slicer works on the table.

What does not work:

Bar chart displaying only Top N as in the table visual but as total sales per category. For example: top 5 product divided across categories and if slicer set to 15 than 15 product divided and sumed per category.

Instead bar chart picks on all sales despite it having also DisplayTopN = 1.

Please your help.

Thank you.

[OLM · Accepted solution]

Thank you for the help. In the end I have solved it using an aggration measure, ranking measure and a display measure. 

[OLM]

I will fix something. But for now, can you share an example of a dashboard with a dynamic Top N slicer filtering a bar chart? It should be a common requirement, but surprisingly not easy to find one conclusive approach.

[Ashish_Mathur]

No one wants your actual data.  Share some dummy data, explain the question and show the expected result.  Share data in a format that can be pasted in an MS Excel file.