Top 3 shows correctly but Top 2 doesnt

[stribor45]

Can anyone suggest what am I doing wrong? In  my matrix visual the Top 3 show correctly in this order

569

401

342

but as soon as I change it to  top 2 it shows 

569

342

any suggestions help would be appreciated.

Thanks

[stribor45]

@Ashish_Mathur Can you let me know if you can access it, My data 

[Ashish_Mathur]

Access Denied message.

[stribor45]

@Ashish_Mathur can you try now please

[Ashish_Mathur]

Share the download link of the PBI file.

[stribor45]

@Ashish_Mathur can you let me know if you can access this file Top N Test . 

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[stribor45]

@Ashish_Mathur I am looking at it now and works fine but I want to understand what's happening. Your measure "Total" is sum of values in ID column but how does it know to sum it by month?

[Ashish_Mathur]

Hi,

Since the month field has also been dragged to the visual, the measure considers that as a filter condition.

[stribor45]

thank you @Ashish_Mathur . I have the last question...is it possible to show a chart like this. sorry bad drawing 😞

[Ashish_Mathur]

I cannot understand what tiy want in those columns

[stribor45]

Hi @Ashish_Mathur I have two questions...

1. Can fruits perhaps be put in common categories? As an example is there a way to put Tomato and Peanuts into the "Vegetable" group and everything else into the group "Fruits" so each month would have "Vegetable" and "Fruits" showing the total for each?
2. For the chart this is what I was thinking about in my previous post (see image) so each bar will represent one category ("Vegetable", "Fruits")
3. I could potentially have more categories

[Ashish_Mathur]

Hi,

You can create a 2 columns table with Fruits in column 1 and Categories in column 2.  Create a relationship between the tables and now drag Categories to your visual from the new table

[stribor45]

I figured it out regarding categories. I see what you mean now. I created the slicer using the calendar table I made. I am having some trouble sorting it so it shows YYYY-MM in sorted order. Below is my slicer and table I use for it

[Ashish_Mathur]

Please read up on "Sort by column" in the Data Model.

[stribor45]

You mean like this?

[stribor45]

How can I create a table whose first column has unique values for fruits and the second column has only two values ("fruits", and "vegetables"). The first column has 14 rows while the second would have only two.

[stribor45]

do you think you can try if I send you the file?

[stribor45]

In power BI top 5 works and the top 4 works but as soon as I hit the top 2 and top 1 it doesn't show correctly

[stribor45]

I did this in pivot. I showed top 3 and it showed exactly as in Power BI but I then had to sort based on count id from largest to smallest and then it showed up properly.  I have to figure this out now in my Power BI matrix visual.

[stribor45]

@Greg_Deckler this is what it looks like now...