Forum Discussion

Jan845's avatar
Jan845
Icon for Helper I rankHelper I
2 years ago
Solved

How yo order funnel chart by measure values?

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!

  • 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

1 Reply

  • 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