Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Top 10 values in Matrix visual

Hi Community..!! Please refer a below image.This is a matrix visual     I want to display top10 columns, expect both side left colored columns (these are PY and CY share). I am using share...
Need Help
Show and Tell
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, Anonymous 

    You need a rank measure first:

    Rank =
VAR tab =
    SUMMARIZE ( ALL ( Sheet1 ), Sheet1[Row], "_Share", Sheet1[share%] )
RETURN
    RANKX ( tab, Sheet1[share%],, DESC, DENSE )

    Then you may need to create multiple measure to replace your original column values.

    Similar to the following:

    New Column2 =
IF ( [Rank] <= 10, SUM ( 'Sheet1'[Column2] ), BLANK () )

    New Column3 =
IF ( [Rank] <= 10, SUM ( 'Sheet1'[Column3] ), BLANK () )

    .....

    If it doesn't work, please share a sample pbix file for further research.

    Best Regards,
    Community Support Team _ Eason

     

  • Anonymous's avatar
    Anonymous
    3 years ago

    Thank U v-easonf-msft 

v-easonf-msft's avatar
v-easonf-msft
Community Support
3 years ago

Hi, Anonymous 

You need a rank measure first:

Rank =
VAR tab =
    SUMMARIZE ( ALL ( Sheet1 ), Sheet1[Row], "_Share", Sheet1[share%] )
RETURN
    RANKX ( tab, Sheet1[share%],, DESC, DENSE )

Then you may need to create multiple measure to replace your original column values.

Similar to the following:

New Column2 =
IF ( [Rank] <= 10, SUM ( 'Sheet1'[Column2] ), BLANK () )

New Column3 =
IF ( [Rank] <= 10, SUM ( 'Sheet1'[Column3] ), BLANK () )

.....

If it doesn't work, please share a sample pbix file for further research.

Best Regards,
Community Support Team _ Eason

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank U v-easonf-msft