Why have two charts when you can have one? And this one keeps the same scale and context too!
Create a chart that shows both top and bottom 5, 10, or parameterized value the user can choose, values by a category.
Create the parameter
Click Modeling ribbon
Click Parameter button
Type in name for the parameter, "Top/Bottom X"
Type in a minimum, 1
Type in a maximum, 20
Type in a default, 5
Click "OK"
A table will be created with your parameter values and measure to access the current picked value. This is DAX you can edit later.
DAX Measure
Put it together
Create your bar chart with category and value measure used
Select visual and open filter pane
Add the "Rank Measure by Column Flag" measure to "Filters on this visual".
Filter it to equal 1.
Comments