Forum Discussion

izhilin's avatar
izhilin
Frequent Visitor
7 years ago

Sort by column a table with dynamic formula - not working in September 2018 version

Dear Colleagues,   I know this question was raised many times, seems this is still a problem in September 2018 version (Version: 2.62.5222.761 64-bit (September 2018)).   I am creating a KPI tabl...
Need Help
izhilin's avatar
izhilin
Frequent Visitor
7 years ago

Thanks for the suggestion. I tried to add space before the values, but this did not influence dimension sorting.

UPD: I removed all line breaks in the measure formula, and it actually seems to work.

 

Any ideas why line breaks or tabs in the measure influence table sorting?

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, izhilin

I've been using this Sort by feature a lot lately, it works well. and I have tested on my side, but not reproduce the issue.

For example:

and then select column KPI Name ->click sort by Column->Sort column

Result:

And it doesn't be influenced by line breaks or tabs, and why it is Sorting column (Default) in your screenshot?

Reference:https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

 

and here is my pbix, please try it.

https://www.dropbox.com/s/vq6mpfiygkdk3gv/Sort%20by%20column.pbix?dl=0

 

If not your case, please share your simple sample pbix.

 

 

Best Regards,

Lin