Forum Discussion
Dynamically Changing TopN for Sankey Across Multiple Columns with All Others
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.
2 Replies
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.
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.
