Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

How to sort Qtr chart ?

Hi All I am using Qtr sort expression , yet i cannot get it sort. where go wrong ? Qtr Sort = Format([date],"YYQ")

ryan_mayu
5 years ago
Anonymous

select quarter column and sort by column qty sort. below is the attachment for your references.

Anonymous

Not applicable

5 years ago

Anonymous - Click on three ellipses of the bar chart (can be seen when you select the chart, in the top right)

And there You will get an option of Sort By- Sort there by quarter and see if it helps.

Anonymous

Not applicable

5 years ago

Hi Sir

I have try that already but it still not sort by Qtr.

Anonymous
Not applicable
5 years ago
Hi Sir
- mahoneypat
  Microsoft Employee
  5 years ago
  Did you already set up the Sort By column for the column you want to use with the YYQ column?
  
  https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
  
  If so, you should be able to add your Q1-20, etc. column to the X-axis and then click on ellipsis to sort by it.
  
  Regards,
  
  Pat
- ryan_mayu
  Super User
  5 years ago
  Anonymous
  
  Select QTY colum and sort by QTY SORT.
  - Anonymous
    Not applicable
    5 years ago
    Hi Sir
    I still unable to sort it. below is my PBI file. Hope you can help me sort.0

Related content