Stacked Bar Chart - Need to Sort by Percentage

[dkernen]

Good morning.  I do hope you PBI wizards can help me.

I have four categories of Registered - Yes, Intent, No, and Missing.  I have filtered out the Missing as Valid Registered.

What I want is a stacked 100% bar chart that sorts descending by percentage (share) of the Yes.  When I use the 100% stacked bar chart, it sorts only by counts, which is not what I want.  

When I use the stacked bar chart, I get the right metrics, but when I use the stacked bar chart, it filters the denominator so every category is treated as 100%.  (See the screenshot below - the metrics are showing correctly in the cards, and incorrectly in the stacked bar).  

I am relatively new to the PBI community, so I would very much appreciate some guidance as to what to do.  I have included a link to a dataset hoping that one of you can assist.  I am grateful for this group!

Please see the link to my file: https://1drv.ms/u/s!AiPFJOtfNkzegeZ_TZAVWDM26Z8Q-A?e=NpfFzX

@StackedBar, @StackedBarSorting, @PercentageOfTotal

[dedelman_clng · Accepted solution]

Hi @dkernen .

First off, thank you for a post with clear, detailed information and for inclulding your pbix from the start.

I've attached a copy of your report file at the bottom. Look on Duplicate of Page 1 and hopefully that is what you're looking for.  Here's what I did:

1) For [Valid Registered] I modified your code to

VR2 =
CALCULATE (
    [Cases],
    FILTER ( ALL ( dimODisp ), dimODisp[Registered] <> "Missing" )
)

2) For [Registered %], I used my VR2 measure

Reg % 2 = DIVIDE([Cases], [VR2])

3) For your sorting issue, I created a new measure [Reg Y]

Reg Y =
DIVIDE (
    CALCULATE ( [Cases], FILTER ( ALL ( dimODisp ), dimODisp[Registered] = "Yes" ) ),
    [VR2]
)

4) Finally, using the Stacked Bar Chart, with [Reg % 2] as "Value", I put [Reg Y] into the Tooltips, which allowed me to sort, in descending order, by the number of "Yes" records.

Hope this helps,

David

[dkernen]

@dedelman_clng 

Words cannot express my gratitude.  This is EXACTLY what I needed.  Thank you so much.  I am blessed!