Forum Discussion
Hide Sorted Column - Table Chart
Hi There,
I have a source of table, it contains 3 columns.
| ID | Fruit | Active |
| 4 | Apple | Y |
| 3 | Banane | Y |
| 2 | Orange | Y |
| 1 | Mango | Y |
| 5 | Kiwi | N |
I am using the visualization "Table".
I want to show only Fruit column, like a table, because user will select the fruit.
It will affect other charts later on.
I want to show only Active Fruits.
I want to show Fruits in Sorted Order 1...5
However I do not want to workaround such
- set the color of column header and value to white color.
- set the column width to 0
How I can show active, sorted Fruits without doing any workarounds?
I am using Power BI - desktop - Version: 2.110.1085.0 64-bit (October 2022)
Many Thanks,
Aykut
Hi,
In the Data tab, sort the Fruit column by the Sort Order column.
And finally I found the solution here at powerbi.com 🙂
Solved: Sort Slicer Value By A Different Column - Microsoft Power BI CommunityHi,
It works just fine. See the screenshots below
7 Replies
If I understand your question clearly. The below can be the possible solution.
If you only want to show the active fruits, you can set the page filter as below.
I want to show only Active Fruits.
I want to show Fruits in Sorted Order 1...5
I want to show only Fruit column, like a table, because user will select the fruit.Hope it helps, if not please provide a sample output that you desire.
Hi AbbasG,
Thank you for your feedback.This was the original list.
SortOrder Fruit Active 4 Apple Y 3 Banana Y 2 Orange Y 1 Mango Y 5 Kiwi N I want to show the Fruits in Sorted Order
Fruit Mango Orange Banana Apple So, how can I make the sort without showing the column?
Thanks, Aykut
Hi,
In the Data tab, sort the Fruit column by the Sort Order column.
And finally I found the solution here at powerbi.com 🙂
Solved: Sort Slicer Value By A Different Column - Microsoft Power BI Community
