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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Sixian
Frequent Visitor

How to create a view with the largest three values for each row

I'm struggling with a couple of problems in the same project and I'll post two different help request.

You can find the Problem 1 in this post: https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-filter-a-page-with-different-attribute...

 

Problem 2.

I have a table with more than 80 Attributes, like this:

ScreenShot 041.jpg

I want to create a page with a view that shows the largest three attributes for each name, like this:

ScreenShot 045.jpg

 

I would really appreciate any help.

Thank you

4 REPLIES 4
Sixian
Frequent Visitor

I still can't find a way to unpivot my Attributes Table.

I can't do it in power query, because it is a calculated table, created using the following DAX code:

AttributesTable =
var filteredTable = FILTER('InputTable', 'InputTable'[Exclude] = "NO")
return SELECTCOLUMNS(filteredTable,
"Name", 'InputTable'[Name]
)

 

Then, all the more than 80 attributes have been added as calculated columns using DAX code.

Please, any help?

Thank you

wdx223_Daniel
Super User
Super User

think you can use generate instead of addcolumns

wdx223_Daniel
Super User
Super User

firstly, you need to unpivot your data like this

wdx223_Daniel_0-1611219366704.png

then add a dimension table like this

wdx223_Daniel_1-1611219395734.png

then create two measures

Attr = CALCULATE(MAX('Table'[Attribute]),FILTER(VALUES('Table'[Attribute]),RANKX(ALL('Table'[Attribute]),CALCULATE(MAX('Table'[Value])))=MAX('TopN'[Index])))
Val = CALCULATE(MAX('Table'[Value]),FILTER(VALUES('Table'[Attribute]),RANKX(ALL('Table'[Attribute]),CALCULATE(MAX('Table'[Value])))=MAX('TopN'[Index])))

then show the view you want 

wdx223_Daniel_2-1611219497851.png

 

My Data Table is a calculated table where I added all the Attributes columns using formulas. How can I unpivot the table?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors