Dynamically Changing TopN for Sankey Across Multiple Columns with All Others

[alwalker]

I'm trying to create a dynamic Sankey in Power BI that filters according to two groups with slicers. Initial data look like this: 

I'm trying to create a dynamic set of slicers that so users can see the top univ (To) and have the remaining two listed as "Others"

Is this possible with Power BI? Thanks in advance. 

[jdbuchanan71]

Hello @alwalker 

Take a look at this post https://www.oraylis.de/blog/show-top-n-and-rest-in-power-bi.  Lukas does a great job walking through the logic to get what you are looking for.

[alwalker]

 @jdbuchanan71 Thank you for this. I have spent the better part of my afternoon yesterday and my morning this morning trying to get this to apply to my Sankey with little success. It's difficult because I need to have the "Others" applied to the second column of the Sankey (VA and PA). I'm really struggling with this so if anyone can assist, i would greatly appreciate it.