How to sort Qtr chart ?

[Anonymous]

Hi All

I am using Qtr sort expression  , yet i cannot get it sort. where go wrong ?

Qtr Sort = Format([date],"YYQ")

[Anonymous]

@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]

Hi Sir

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

[Anonymous]

Hi Sir

[ryan_mayu]

@Anonymous 

Select QTY colum and sort by QTY SORT.

[Anonymous]

Hi Sir

I still unable to sort it. below is my PBI file. Hope you can help me sort.0

[ryan_mayu · Accepted solution]

@Anonymous 

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

[Anonymous]

Hi Sir

Thank you very much. it work fine now.

[mahoneypat]

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