Top N with What If Parameter

[Anonymous]

Hello,

I am currently using TOP N with What If parameter to rank Revenue by Company Names, it is working fine but there maybe cases where Company Names maybe same and in such scenarios, the revenue will get summed for those company names. If I use "Company Key" to rank, I can no longer use Company names on the Axis of the bar graph. It shows a "ran out of memory exception". How do I handle this in Power BI?

Thanks in advance.

[Anonymous · Accepted solution]

This requirement is not possible. I can not use Column 'A' to rank and then use 'Column B' on the axis. Apologies for the wrong question posted

[v-danhe-msft]

Hi @Anonymous ,

Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Daniel He