Forum Discussion
Sort by column a table with dynamic formula - not working in September 2018 version
Hi,
Can you use space before the " Open Receivables", " Open Payables", " Liquidity" in your function so they can be aligned automatically based on your requirement.
Thanks
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?
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
