Forum Discussion

cn4422's avatar
cn4422
Helper V
6 months ago
Solved

Sorting specific column in matrix visual

Hello,   I'm trying to sort my matrix table (link to Power BI File) by a specific column, in my case Leads for ContactGroup "A". In the past is was possible to simply add a measure as a tooltip an...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    6 months ago

    Create a measure that calculates Leads for ContactGroup A:

    Sort Leads A =
CALCULATE(
    [Leads], 
    'ContactGroup'[ContactGroup] = "A"
)

     

    Add this measure to the matrix:

    • Put it in Values

    • Turn off visibility:

      • Set column width very small, or

      • Rename to blank, or

      • Hide via conditional formatting (font = background)

    Then: Matrix → More options (…) → Sort by → Sort Leads A

cengizhanarslan's avatar
cengizhanarslan
Super User
6 months ago

Create a measure that calculates Leads for ContactGroup A:

Sort Leads A =
CALCULATE(
    [Leads], 
    'ContactGroup'[ContactGroup] = "A"
)

 

Add this measure to the matrix:

  • Put it in Values

  • Turn off visibility:

    • Set column width very small, or

    • Rename to blank, or

    • Hide via conditional formatting (font = background)

Then: Matrix → More options (…) → Sort by → Sort Leads A

  • cn4422's avatar
    cn4422
    Helper V
    6 months ago

    cengizhanarslan @  Thanks for your replay. I actually thought about that too, but I was wondering if there is a "cleaner solution" as well

     

    But if nothing else comes up I will either do that or make separate measures for every columen cause then I can sort individually by everything.

     

    Edit:
    I think I'll go with this. In addition, I formatted my measure with ";;;" so that the one column with values makes the values "invisible" as well.