Sorting problem

[Anonymous]

So I've build a stacked diagram (as seen below), and I would like to sort the diagram by the percentage shown in the tooltip. I don't have that percentage as a field, only the ammount (914.508 kr.). Is that possible and if so how?

Maybe I need to do some calculations first.

Best regards

Janus Heisterberg

[vanessafvg]

hi @Anonymous 

have you used the sort on the diagram?  ie top right of object  try sorting by ascending or descending?  if that doesn't work you probably need to craft your own measures

[Anonymous]

Hi @vanessafvg 

Thank you for your help. 

I have tried sorting by that, unfortunately, the value I want to sort by isn't available. 

So as you say, I probably have to create my own measure - but I was hoping to avoid that, since Power Bi already has the value. 

/Janus