Top 10 values in Matrix visual

[Anonymous]

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% measure to display top 10 columns into the matrix visual. The columns which are red in color (PY and CY) should be constant and remaining in between columns should be top 10 (number of columns = 10).

Can we achieve this in to the matrix visual?

please help me to solve this.

[v-easonf-msft · Accepted solution]

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

[v-easonf-msft]

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]

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 · Accepted solution]

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 · Accepted solution]

Thank U @v-easonf-msft