Forum Discussion

New Member

6 years ago

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

Community Support

6 years ago

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.