How yo order funnel chart by measure values?

[Jan845]

Hello, everyone!

I've created a funnel chart with 10 measures to count the number of applications in the Subcategory column.

However, I've added these measures to the chart, and I can't sort them by value.

Is that possible? Does anyone have any tips to help me please?

My PBIX file

Thank you all very much!

[amitchandak · Accepted solution]

@Jan845 , Create a calculation group of all measures. With Each Item having same name as measure.

Use calculation group name in Category and any meausre in funnel

Now sort on measure name it will do that

Example with three

Model explorer public preview with calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU