cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Post Prodigy

## Top 3 shows correctly but Top 2 doesnt

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

23 REPLIES 23
Post Prodigy

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

Super User

Regards,
Ashish Mathur
http://www.ashishmathur.com
Post Prodigy

@Ashish_Mathur can you try now please

Super User

Regards,
Ashish Mathur
http://www.ashishmathur.com
Post Prodigy

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

Super User

Hi,

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Post Prodigy

@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?

Super User

Hi,

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

Regards,
Ashish Mathur
http://www.ashishmathur.com
Post Prodigy

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

Super User

I cannot understand what tiy want in those columns

Regards,
Ashish Mathur
http://www.ashishmathur.com
Post Prodigy

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
Super User

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

Regards,
Ashish Mathur
http://www.ashishmathur.com
Post Prodigy

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

Super User

Regards,
Ashish Mathur
http://www.ashishmathur.com
Post Prodigy

You mean like this?

Post Prodigy

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.

Post Prodigy

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

Post Prodigy

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

Post Prodigy

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.

Post Prodigy

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

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors