column header sorting in Direct Query

[Anonymous]

Hi folks,

I have a fact tabel, person table and dates table in connection with direct query. I want to sort column header in result table as given screenshot below in direct query mode. also there is year filter applied to this result table.

Will appreciate it if any help.

Thank you.

Direct Query data source

Result Table

[v-eachen-msft]

Hi @Anonymous ,

You could pivot "WeekHeader" column and use sum of "Values" as value.

Or you could use matrix visual to show your data, you need to put "WeekHeader" column in the "Columns" section.

[Anonymous]

Hi @v-eachen-msft ,

Thanks for your response on this issue.

Obviously, I can use a matrix or pivot the column in power query for this visual, but the issue is here to sort header like in result visual.

for example, in visual I have column header in ascending order "week of Jan 1, week of Jan 2, week of Jan 3, week of Feb 1, week of Feb 2, week of Feb 3.......week of Oct 1, week of Oct 2, week of Oct 2, week of Nov 1, week of Nov 2, week of Dec 1, week of Dec 2, week of Dec 3". and when I select any 3 months, for example, Aug, Sep, Oct from month slicer for any particular year 2019 then column header should show week of Oct 3, week of Oct 2, week of Oct 1, week of Sep 3, week of Sep 2, week of Sep 1, week of Aug 3, week of Aug 2, week of Aug 1.

can we solve this issue by using a matrix and pivot the column header in this case?

[v-eachen-msft]

Hi @Anonymous ,

I am afraid that column header doesn't support "sort" feature.

[Anonymous]

Folks, is there any solution in Power BI?

Hi @v-lid-msft , please help with this issue?