Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have made a calculate column:
Inactive Group = Calculate( IF('.....'[Days in-active] < 30; "< 30 days"; IF( '.....'[Days in-active] < 90; "30 < 90 days"; IF('.....'[Days in-acitve] < 365; "90 < 365 days"; "> 365 days"))))
Now I become de coloms as follow:
< 30 days | > 365 days | 30 < 90 days | 90 < 365 days
It should be:
< 30 days | 30 < 90 days | 90 < 365 days | > 365 days
How can I do that?
Must I something change in the formula?
Solved! Go to Solution.
Hey,
you can't change the order by changing your formula. The default order is derived from the values of signs representing the character code.
For this reason I would recommend to create a new table in the modeling section using this DAX statement
Inactive Group = UNION( ROW("Inactive Group", "< 30 days", "Sort Order", 1) ,ROW("Inactive Group", "30 < 90 days", "Sort Order", 2) ,ROW("Inactive Group", "90 < 365 days", "Sort Order", 3) ,ROW("Inactive Group", "> 365 days", "Sort Order", 4) )
Next change the default order, goto the model pane mark the column of "Inactive Group" and choose colum to sort by
In the relationship pane connect the columns with the new table on the one side and your calculated column on the many side. Hide your calculated column from report view and just use the column from the new table.
Hope this helps
Hey,
you can't change the order by changing your formula. The default order is derived from the values of signs representing the character code.
For this reason I would recommend to create a new table in the modeling section using this DAX statement
Inactive Group = UNION( ROW("Inactive Group", "< 30 days", "Sort Order", 1) ,ROW("Inactive Group", "30 < 90 days", "Sort Order", 2) ,ROW("Inactive Group", "90 < 365 days", "Sort Order", 3) ,ROW("Inactive Group", "> 365 days", "Sort Order", 4) )
Next change the default order, goto the model pane mark the column of "Inactive Group" and choose colum to sort by
In the relationship pane connect the columns with the new table on the one side and your calculated column on the many side. Hide your calculated column from report view and just use the column from the new table.
Hope this helps
Hi Tom
In this case the headers are numeric and special charachters, what if I want to move one column left or right?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |