Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

Sorting of Funnel chart on the business process for a dashboard

Posted on by Microsoft Employee

I have an existing funnel chart on a dashboard that is sorting the stages of the business process in the wrong order. How do I define the order the stages should be in? 

  • Suggested answer
    LuHao Profile Picture
    LuHao 40,872 on at
    RE: Sorting of Funnel chart on the business process for a dashboard

    Hi Sandi,

    We can manually add the xml code to sort it in ascending alphabetical order by stage name.

    For example, the chart's category is ‘status’.

    pastedimage1573540148986v5.png

    The steps are 1) export the chart, 2) add the sort code line, and 3) import the chart.

    pastedimage1573540201936v6.png

    Add <order alias="stepname" ascending="true" /> between <entity name=...> and </entity>.

    Annotation-2019_2D00_11_2D00_12-143409.jpg

    pastedimage1573541099086v7.png

    It will be sorted in ascending alphabetical order by category label. (L > O > W)

    pastedimage1573541126810v8.png

    If your stage is not in alphabetical order by name, then I recommend that you add a first letter for the stage name, such as 1-Qualify, 2-Develop, so that the stages can be arranged in the order you want.

  • lefmapeach Profile Picture
    lefmapeach 15 on at
    RE: Sorting of Funnel chart on the business process for a dashboard

    A funnel chart will automatically order the stages with the one having the more $ or # on top, then funneling down to the one that has less. Maybe the funnel chart is not the best display for what you're trying to achieve.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans