Forum Discussion

kkanukurthi's avatar
kkanukurthi
Helper III
1 year ago
Solved

Unable to sort Matrix visual column values while clicking on column headers

Hi All, Need help on sorting Matrix column values ascending or descending. Values calculated by measure. Scenario I have a matrix visual in a Power BI report: Rows: "Category" column from the Ord...
Need Help
Show and Tell
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi kkanukurthi ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    In Table visual, It is not possbile to represent  Month-Year placed horizontally with categories in rows. And in Matrix visual, it is not possible  to sort the values under column headers.

     


    If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
    Thanks and Regards

kkanukurthi's avatar
kkanukurthi
Helper III
1 year ago

Hi All, Need help on sorting Matrix column values ascending or descending. Values calculated by measure.

Scenario

I have a matrix visual in a Power BI report:

  • Rows: "Category" column from the Orders table (A,B,C,D,E etc).
  • Values: A measure that Picks icon and Day values from the Ship Date column from Orders table.
  • Columns: A field from a Calender table that contains Months and Years as text column sorted by yearmonth code(formatted as "mmm yyyy", e.g., Apr 2025, Mar 2025).

 

Measure used in values:

Date_Format_Sign =
var month_year = SELECTEDVALUE('Calendar'[Start of Month])
var mindate = CALCULATE(min(Orders[Ship date]),ALLSELECTED('Calendar'))
var minday = day(mindate)
var mindatestartofmonth = date(year(mindate),month(mindate),1)
Return
IF(mindatestartofmonth=month_year,
switch (TRUE(),
minday >=1 && minday<7,UNICHAR(9650)&minday,
minday >=7 && minday<14,rept(UNICHAR(160),4)&UNICHAR(9650)&minday,
minday >=14 && minday<=21,rept(UNICHAR(160),8)&UNICHAR(9650)&minday,
REPT(UNICHAR(160), 12)&UNICHAR(9650)&minday), BLANK())

 

 

Expected Output-Month Year column values to be sorted out either in Ascending or descending when we click on column headers

 Please help! Thanks in Advance