cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Display rank by sum of total ignoring legend

Hello all,


I have 50 stacked bars (one for each state). I added "Product" to the Legend. Thus, each bar displays the sales grouped by product:

Capture.PNGExample

I want to create a tooltip that displays the rank ordered by the total sales of each state. However, due to the legend, the tooltip returns three ranking positions per state: one rank for each product.

Is there a way to create a tooltip that sums by state and ignores the Legend?

 

Thanks in advance!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-yulgu-msft Super Contributor
Super Contributor

Re: Display rank by sum of total ignoring legend

Hi @Anonymous ,

 

You could create a rank measure similar to below:

rank =
RANKX (
    ALLSELECTED ( Data_3 ),
    CALCULATE ( SUM ( Data_3[Value] ), ALLEXCEPT ( Data_3, Data_3[State] ) ),
    ,
    ASC,
    DENSE
)

1.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Highlighted
v-yulgu-msft Super Contributor
Super Contributor

Re: Display rank by sum of total ignoring legend

Hi @Anonymous ,

 

You could create a rank measure similar to below:

rank =
RANKX (
    ALLSELECTED ( Data_3 ),
    CALCULATE ( SUM ( Data_3[Value] ), ALLEXCEPT ( Data_3, Data_3[State] ) ),
    ,
    ASC,
    DENSE
)

1.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 27 members 691 guests
Please welcome our newest community members: