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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
cccorpen
New Member

TopN Top Suppliers, w Splicer and 70 Suppliers

Hi, 

 

I need some help. I have around 70 suppliers, I'm trying to pull out the top 10 by each Splicer, which represents different campus departments. My goal is to let campus departments see who their top suppliers are. TopN ofcourse is missing from the Visual Level Filter. Can you help me figure how how to get it back?  Do I need to Group my values or Filters? 

1.JPG

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

 

@cccorpen 

 

Hi, You need to group your Suppliers in one Column.}

 

You can do that in Query Editor, Select All the Suppliers Column --Transform  - Unpivot Columns.

 

If you have more columns, duplicate your Query , remove all the other columns and apply the unpivot.

 

Regards

 

Victor

 




Lima - Peru

View solution in original post

1 REPLY 1
Vvelarde
Community Champion
Community Champion

 

@cccorpen 

 

Hi, You need to group your Suppliers in one Column.}

 

You can do that in Query Editor, Select All the Suppliers Column --Transform  - Unpivot Columns.

 

If you have more columns, duplicate your Query , remove all the other columns and apply the unpivot.

 

Regards

 

Victor

 




Lima - Peru

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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