Forum Discussion
Solved
Visualize top 3 comparable data points to selection
Hi all, I have a table of school assessment scores. I want to be able to filter and pick a specific school and then have Power BI display the top 3 other schools from the dataset that are comparable...
I was able to solve this by creating a static table with a column that contains Selected School, Comparable #1, Comparable #2, Comparable #3. Another column with levels of L1, L2, L3, L4, and L5. I then wrote a measure where I was able to create a virtual table in a variable and generate output appropriately. I then dropped the static column into the x-axis and the the other column into the legend. The measure I created went into the y-axis. I was also able to create other measures to use as tooltips so I could show the actual school names that are returned.
Works perfectly!
I'd like to see the top 3 schools with a similar # tested (between 221-269).
Top 3 by what? highest value?
Note: Hidden synced slicers make for a bad UX and are a nightmare to debug. Please try using the filter pane instead.