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 Power Bi Gurus,
I have an aging bucket field with values (0-7 Days, 8-15 Days, 16-30 Days....up to 120+ Days), and I use a matrix table display the amount by managers by each bucket, but currently, the bucket values columns are not in the order I expect. Please see below.
I ready couple disussion notes from the forum, and I create a "bucket sort" field in my orginal data file with value (1-7), and in the "Data" view, I choose "Bucket sort" column, and click on "Sort by column", nothing happend, it still show the first row with value starting as "3"....Am I following the wrong direction? Please advise how to sort the column values ...
Also, I have a similar problem with this aging bucket field using as a color legend, it also won't show in the expected order.
Any help is very much appreiciated! thank you!!.
Best,
Flora
Solved! Go to Solution.
@Anonymous,
You'll want to select the column you'd like to sort (your aging buckets), and then the column to sort it by (Bucket Sort) in Sort by Column.
In your original case, you were trying to sort Bucket Sort by itself, which wouldn't do anything.
@Anonymous,
You'll want to select the column you'd like to sort (your aging buckets), and then the column to sort it by (Bucket Sort) in Sort by Column.
In your original case, you were trying to sort Bucket Sort by itself, which wouldn't do anything.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |