You can do essentially the same thing, creating your COLUMNSORT column, but do it in the Query Editor with "Add Column", then save and sort by the new column back out in the PowerBI intrerface. It will get rid of the circular dependency.
Thank you for sharing the solution.
1. By using reference table
2. Conditional Column
I was wondering what is the difference between doing it by using Conditional column and doing the same with calculated column.
Steps Followed :-
1. Go to Data Tab
2. Go to Modelling ribon and select New column
3. Create column using reference column according to what we need to sort.
But sorting is not happening and i am getting error that Reference column could not be sort by Calculated column.
Request you to throw light on the same.
Although I have used my sorted column as default column to be used as a sort, Im not able to see my bar chart change the sort automatically.
This option seems to be completely not working when i tried the same procedure and sorted the stacked column chart my chart started showing all as 100% for all items.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.