Ascending data within graph

[sittitek]

Dear all,

I would like to ascend the data value, number, within each bar graph. 

in the picture, it sorts by the alphabet 

thank you very much

[v-yingjl]

Hi @sittitek ,

If you want to sort it by number in the bar chart, you can create a calculated column like this and put it in the legend field:

Column =
VAR _date = [Date]
RETURN
    RANKX ( FILTER ( 'Table', 'Table'[Date] = _date ), 'Table'[value],, ASC, DENSE )

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@sittitek , this will sort only on legend inside the bar. If there are more values control it by subtotal rank

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

[lbendlin]

Note that there is an "i" warning. You are trying to show too much data. Might want to limit it to the top x per date.

Anyway, I don't think the standard stacked bar has the option to sort each individual bar differently.  There might be custom visuals out there that do that.

[sittitek]

Thanks, Ibendlin

this is published data from a general website. 

I will search for custom visuals as you recommend. thank you.