The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello Everyone,
I have a column in my table for "Country". To sort the countries in a specific way, i created another column by using below formula:
Country_Sort =
Solved! Go to Solution.
@Anonymous ,
Create a new column
Country 1= 'Table' - [Country]
then
Country_Sort =
@Anonymous
When you create a Calculated column in the Report View you will get this error because the column which is created based a Column Cannot Sort the Same column because is Dependent on that Column (with a Formula).
Create a Custom column in Power Query Editor ,with the same logic and use that column for sorting . you will be successful
I am sure this will be a solution for you and if so kindly share your Kudos and mark this as solution.
Regards
Vijay Perepa
Proud to be a Super User!
@Anonymous ,
Create a new column
Country 1= 'Table' - [Country]
then
Country_Sort =