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.
Hi guru,
I do not know how to resolve this problem and hope you can provides some guidance.
The following is my aging bucket barchart and you will notice the sorting is incorrect as "3-30 days" bucket should be next to "0-3 days" bucket.
The barchart bucket sorting is based on File Date columen.
I tried to sort by other columns, but i got the following error message.
Hope you can shed some light. Thank you.
Regards
Aiyo
Solved! Go to Solution.
Hi all,
I found the solution ...
This is because I created a calculated column referencing another calculated column. This become the circulated issue not allow in Power BI.
I have using the same method but referencing a non calculated column.
It works.
@aiyosap
Create another column with the same logic as Aging Bucket but instead of generating the output as '0-30, 30-60 and so on give it a number like 0,1,2 and you can use this column as you sort by column.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi Fowmy,
I had tried the way you mentioned but I encountered the following error message:
The "Age Sort Ind" field are using:
If Age Range = "0-3 Days", 0,
if Age Range = "3-30 Days", 3,
if Age Range = "30-60 Days", 30, 60
The index field populates with correct value.
I have also tried changing the data type (i.e. text and whole number) to the "age sort ind" field, but when come to sort the "age range" field by this new created field, i hits the above error message.
Do you know why?
Thanks,
Aiyo
Hi all,
I found the solution ...
This is because I created a calculated column referencing another calculated column. This become the circulated issue not allow in Power BI.
I have using the same method but referencing a non calculated column.
It works.
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |