Forum Discussion

JosephL's avatar
JosephL
Regular Visitor
8 years ago
Solved

Combining Top N filters

Dear All, I am new to Power BI Desktop and would like some help here.   I am trying to find a method to compare the Top N filtered companies by the profit of two separate periods so that the Top N...
  • JosephL's avatar
    JosephL
    8 years ago

    Nevermind, I have found the way to solve the problem myself, still thanks v-yuta-msft for attempting to solve my problem.

JosephL's avatar
JosephL
Regular Visitor
8 years ago

Dear All,

I am quite new to Power BI Desktop and I am still wrapping my head around the functions of this software.

 

I am currently trying to compare the sales of various companies and I would like to display only the Top N companies, e.g. 5, based on the sales of either the specified period in a year (monthly or weekly based on a date table of mine) and the period of the year before, which results in at least 5 companies and a maximum of 10 shown, if the sales vary significantly between years.

 

I would like some guidance on this matter and thanks in advance.