Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Only Show Power BI Matrix value at Row Grand Total

Is there a way to have a Power BI matrix value ONLY show on the totals?

I have them shrunk so they're not seen, but this rolls every week so it becomes a weekly task to hide.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    we're hiding the extra columns that use the custom sort. We've also floated the idea of doing the custom sort computition in the data warehouse each night. Then we make a separate name table with their daily rank. We would then sort names by this value.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    3 years ago

    Hi, did you manage to solve this? I'm hiding the columns, but it's still doing the calculation for each one that slows down the table.