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 a table visual with multiple columns including various measures. When I try to sort ASC by a measure column, the blanks in that column are all brought to the top because they are treated like zeros. I want the blanks to always be at the bottom and not be included in the sorting. (I tried adding an empty space to the blank values making them a string, but then the blanks appear at the top when I sort the column DESC.) Is there any work around to do this? Thank you!
Solved! Go to Solution.
Hi, @meirlicht
Inevitably you will need to add custom index columns for sorting.
You need to add that index column to the chart, then hide the sort column by shortening the column width after sorting.(turn off word wrap in the table/matrix setting and drag the field)
Best Regards,
Community Support Team _ Eason
Hi, @meirlicht
Inevitably you will need to add custom index columns for sorting.
You need to add that index column to the chart, then hide the sort column by shortening the column width after sorting.(turn off word wrap in the table/matrix setting and drag the field)
Best Regards,
Community Support Team _ Eason
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |