Forum Discussion
Helper IOrder bar chart - low to high
I have the below bar chart that uses 3 separate measures. Is there any way to order my bar chart so that it shows the figures low to high?
Hi, Redraidas1
If you only have some measures to display, I have a workaround. You need to use 'enter data' to enter the names of measures,then create a new measure instead of your original measures,then use it in visual.
Like this:
Measure 3 = SWITCH(SELECTEDVALUE('Table (2)'[Column1]),"Measure",[Measure],"Measure2",[Measure 2])If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Redraidas1 , You can not sort on multiple measure value.
If you need, you can create a measure/column to dimension and then sort it.
- v-janeyg-msft
Community Support
Hi, Redraidas1
If you only have some measures to display, I have a workaround. You need to use 'enter data' to enter the names of measures,then create a new measure instead of your original measures,then use it in visual.
Like this:
Measure 3 = SWITCH(SELECTEDVALUE('Table (2)'[Column1]),"Measure",[Measure],"Measure2",[Measure 2])If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
