Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Hiding A Sorting Row in A Matrix

Please help me with my Matrix.

 

I have a matrix I created so that users can drill down to lower levels to see what values live underneath them.

 

The problem I am having is that I want to sort by a numerical value that must not be displayed visually.  This is because the numerical values translate to a text value that WILL be displayed, but not sorted on.

 

For instance, we have sorted in the proper order:

 

Cash

Marketable Securities

Accounts Receivable

Allowance

Notes Receivable

 

A picture says it all, so I will paste my workspace here.  Sorry, but the community forums won't let me make this any bigger:

 

 

Here is a bigger version:

 

 

You can see that I have "LEVEL", which displays as a number, such as 1000, 1010, 1020, and so on.  This is what I am using to sort by.  I still need to maintain this sort, but eliminate the display of these sort numbers and the "Total" that it is printing for these sort numbers.  That way we only see, with no blank lines or other values:

 

Cash                                           $..............

Marketable Securities                $..............

Accounts Receivable                  $..............

Allowance                                   $..............

Notes Receivable                        $..............

 

Thanks.

 

 

 

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    So is there no way to do this?  My question just got pushed to the second page of the forum.  Can anyone recommend any other forums where there are more Power BI Users?

     

    Thanks.