cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joshuavd
Frequent Visitor

Custom Sorting not working

I have been following the advice of many threads on a custom sort option but have not been able to figure this out.  All the values in the chart show as the same height (the total record count) instead of their respective values by category.  What I have:

 

  • Table filled with 76 records, relevant to this question is the column "From Stage" which has 3 possible values
    • BANT Complete
    • Proposal/ROI
    • Negotiation/Review
  • Table (Manually Created) that links to "From Stage"
    • Stage (populated with 3 rows, of the above values)
    • Sort Order (populated with 3 rows, values of 1-2-3)
  • I created a chart and used the manually created table's "from stage" as the x-axis and for the y-axis the count of "from stage" from my record filled table
  • The result is 3 columns
    • BANT Complete -76 Records
    • Proposal/ROI - 76 Records
    • Negotiation/Revie - 76 Records

 

Any idea why that is not filtering correctly?  I expected to see:

  • BANT Complete -21 Records
  • Proposal/ROI - 36 Records
  • Negotiation/Revie - 19 Records
1 REPLY 1
Super User IV
Super User IV

Re: Custom Sorting not working

hi @joshuavd


Do you perhaps have an image that you can share of your sample data?

As well as what it currently looks like?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors