Forum Discussion
Ascending data within graph
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
4 Replies
- lbendlinSuper User
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.
- sittitekNew Member
Thanks, Ibendlin
this is published data from a general website.
I will search for custom visuals as you recommend. thank you.
- amitchandakSuper User
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/367415 - v-yingjlCommunity Support
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.