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

Hans-Georg_Puls's avatar
Hans-Georg_Puls
Super User
6 months ago

Hi cn4422 ,

a quick solution would be to add "SumLeads A" as Value, switch off "text wrap" for values and column, reduce the column width of all "SumLeads A" columns to zero and adjust the sort by setting of the matrix visual. Only the little triangle couldn't be removed:

Does that help you?

  • cn4422's avatar
    cn4422
    Helper V
    6 months ago

    Hans-Georg_Puls  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.