Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
MOORE020
Frequent Visitor

Top N Slider - Unexpected results after adding legend

All, I am trying to do a Top N slider.  An issue I am experiencing is that I cant seem to include an additonal column without it skewing my dense ranks.  The first image is what I would expect it to be, but when I go to add an aging category, it throws the ranks off kilter.  

MOORE020_0-1664832595226.png

MOORE020_1-1664832666953.png

 

Disposition Rank = RANKX(ALL('Daily Comments'[Disposition]),'.Calculations'[D_SumBalanceDue],,DESC,Dense)
 
D_TopDispositionsByBalance =
CALCULATE('.Calculations'[D_SumBalanceDue],
FILTER(
VALUES('Daily Comments'[Disposition]),
IF(
RANKX(ALL('Daily Comments'[Disposition]),'.Calculations'[D_SumBalanceDue],,,Dense) <='Top XX Dispositions'[Top XX Dispositions Value]
,'.Calculations'[D_SumBalanceDue],BLANK()
)
)
)

 

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi, @MOORE020 

This is normal. When adding an aging category, the values of other fields, such as balance due, will no longer aggregate. You will find that the data row is expanded, but its rank value has not changed for the same disposition.
Can you explain in more detail what you want?

 

Best Regards,
Community Support Team _ Eason

I have a stacked bar chart that I am trying to allow users to slice with Top N Dispositions.  The Bar chart has an aging category that should show as the legend on the bar chart.  Now if they pick the top 5 dispositions, it actually shows 8 different dispositions due to how Power BI is no longer aggregating.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.