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 

Not fully sure what you mant.

Please check if 'TopN' in visual filter pane could work for you.

 

Best Regards,
Community Support Team _ Eason

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi v-easonf-msft 
If I go with the option that u have mentioned above then I will get top10 for all the bars.
my queston is, left  and right most column will be constant(red in border). Expect these columns I want top10 columns in between them.
I Hope now u are clear with the requirement.

  • 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