Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good day.
Simple data below and I want PowerBi a Table display the same.
Name | Order |
John | 1 |
Kate | 2 |
Lilly | 3 |
David | 4 |
Maggie | 5 |
Ted | 6 |
Will | 7 |
Data view looks ok, and it's sorting by the Order column.
But Visual's not. (I only want the Name column in the table.)
The spaces in front of texts are removed, and the sorting seems not working.
How can I have a table shows the texts like above? Thank you.
Solved! Go to Solution.
Hi,
To sort a column based on another one, use the "Sort by column" in the Modeling menu.
To keep the spaces, disable "Word Wrap" in the Values section of the table settings.
Best Regards // Ulf
Hi,
To sort a column based on another one, use the "Sort by column" in the Modeling menu.
To keep the spaces, disable "Word Wrap" in the Values section of the table settings.
Best Regards // Ulf
@amitchandak, thank you! actually I need to choose the Column "Name" to Sort by Column "Order", instead of doing it on "Order".
@UlfBergqvist, thank you for the solution
Have you tried
Refer:
https://community.powerbi.com/t5/Desktop/How-to-trim-space-from-Power-BI/td-p/194308
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |