Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
stribor45
Post Prodigy
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

 

stribor45_0-1685293228931.png

 

any suggestions help would be appreciated.

 

Thanks

 

 

23 REPLIES 23
stribor45
Post Prodigy
Post Prodigy

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

Access Denied message.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur can you try now please

Share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

 

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

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
https://www.linkedin.com/in/excelenthusiasts/

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

stribor45_0-1685667306378.png

 

 

I cannot understand what tiy want in those columns


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

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
https://www.linkedin.com/in/excelenthusiasts/

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

 

stribor45_0-1685727652910.png

stribor45_1-1685727681565.png

 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

You mean like this?

 

stribor45_0-1685719243743.png

 

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
Post Prodigy
Post Prodigy

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

stribor45
Post Prodigy
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

stribor45
Post Prodigy
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.

stribor45
Post Prodigy
Post Prodigy

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

 

stribor45_0-1685313056500.png

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.