Sorting in a Chart

[PBI5851]

Hello,

I am trying to display a Range table and the corresponding data in a column chart. I am able to get the data, but the sorting is the big problem. Not sure how to accomplish this. 

Sort	KeyField	Range	Count
1	North1	0-5	50
2	North1	6-10	45
3	North1	11-14	20
4	North1	15-20	10
1	East1	0-5	60
2	East1	6-15	30
3	East1	16-20	50
1	West1	0-3	38
2	West1	4-9	20
3	West1	10-20	10
4	West1	21-30	50
5	West1	31-35	90

The goal is to display just 

KeyField	Range	Count
North1	0-5	50
North1	6-10	45
North1	11-14	20
North1	15-20	10

and a Column Chart, but i have to include the Sort field too , to force it to display as per requirements. 

Issue 1- Based on my search, i cannot hide the Sort column from being displayed. (My workaround is to use white color as font to "mask it")

Issue 2: When converting to a graph, how to maintain the sort without adding the sort column in axis/legend .

I am unable to "sort by column" due to "there cant be more thatn one value in 'Sort' for the same value ......'

Any recommendations on how to achieve this ?

[Anonymous · Accepted solution]

@PBI5851 

You must create a sort column because the range column is a text type, you cannot sort it like numbers. In addition, you need also use the sort column as the legend. My suggestion is create a tooltip to show the Range data, so when you hover over it the range data displays in the tooltip.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@PBI5851 , You have to create a sort column and mark it as sort column of another column and use that.

refer my video on that. https://www.youtube.com/watch?v=KK1zu4MBb-c

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

Sort column is not needed in visual