Forum Discussion
chrisgehm
9 years agoHelper III
Divide and TOP 10
Hi everyone! I have 1 table in excel with 3 columns Amount1 - Amount2 - Provider I've create a new column in Power BI that makes the difference between Amount1 and Amount2 Lets call it D...
Phil_Seamark
9 years agoMicrosoft Employee
Sorry, here is a slightly taller picture. When you drag an item to the Axis of a visual, down in the Filters you have additional options to filter that Axis. Here you can select the Top (or Bottom) N based on other values.
chrisgehm
9 years agoHelper III
Sorry, still can't find the filter.
- Phil_Seamark9 years agoMicrosoft Employee
See right at the very bottom of your image, the Filter Type drop dow says "Advanced Fitlering". What happens when you click that?