Forum Discussion

shareezsaleem's avatar
shareezsaleem
Helper III
1 year ago
Solved

Show Only Top N In Column Level

Hi All, I have a matrix like below: Level 1    WBS1 WBS2 WB3.....WBS723 MACHS   12       34       44 PAX         28       44       22 ELEC.       60       32      11 Total       100     110    ...
Need Help
  • kushanNa's avatar
    kushanNa
    1 year ago

    Hi shareezsaleem 

     

    did you try to use the Top N filter on the filter panel? 

     

     

     

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi shareezsaleem You could use DAX to calculate total for each column and then rank them and apply filter in Matrix ..... Please try this out
Calculate Total for Each Column:

TotalValuePerColumn = SUM('Table'[Value])

Replace value with your numerical column
Rank Columns:

RankColumns = RANKX(ALL('Table'[WBS]), [TotalValuePerColumn], , DESC)

Filter Top 50 Columns:
Apply a filter in the matrix visualization to show only columns where RankColumns ≤ 50