Urgent Help - Top N analyses with Legends

[niteshtrehan89]

Hi team,

I need a urgent dax changes for the TOP N analysis using the legend. if i am not putting the legend in the stacked bar chart then it is working fine but as soon as I put the legend the the TOP N is not working as expected . Legend name is Product.

Below is the dax function, 

TopN Exporter =

VAR SelectedTop = SELECTEDVALUE('Top'[Top])

RETURN

SWITCH(TRUE(),

SelectedTop = 0, [Total Quantity],

RANKX (

ALLSELECTED(MasterData[Exporter Name]),

[Total Quantity]

)

<= SelectedTop,

[Total Quantity]

)

Please help me out asap on the requirement.

[PaulDBrown · Accepted solution]

As @TomMartens says, your request is not very clear.

If you are looking to show values based on a slicer selection for TopN values, this thread might help:

https://community.powerbi.com/t5/Desktop/Instead-Top-N-records-show-inbetween-N-to-N/m-p/2217390#M80... 

[TomMartens]

Hey @niteshtrehan89 ,

I have to admit that I do not understand what you are looking for.

If you need urgent help (be aware that most of us are here in our spare time), take the time and create a pbix file that contains sample data but still represents your data model (tables, relationships, calculated columns, and measures). Upload the file to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the Excel as well.

Do not forget to explain the expected result based on the sample data you provided.

Regards,

Tom