Top N - Month_Year, Technology, Fault, Total Fault, Rank

[Anonymous]

Hi, I am fairly new to PowerBI and trying to create Top N (5) repot.

I have two tables.

- Date Table 

• Date
• Month_Year

-Fault Reasons Table

• Fault ID
• Date Reported 
• Technology
• Reason
• Fault Count (1 for each line)

I am after Top N (5) report based on Month/Year, Technology, Reason, Total Fault Count, Rank (Top 5)

Please provide your suggestion

[v-diye-msft]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution. if not, please share more details about your question, we'd like to provide further support. thanks!

If you've fixed by your own, it would be much appreciated if you can share your solution here. 

[v-diye-msft · Accepted solution]

Hi @Anonymous ,

Did you try the TOP N filter ?

[amitchandak]

1. Load the data to powerbi

2. Create a relation between to tables.

3. Make sure all data types are picked up correctly

4. In visualization later take a filter of  Date. In the latest version, there is filter pane global or local to page explore that.

5. Each Graph or table you should able to select view by/category and measure. Change sorting to measure if required.

For remaining need can you please give an example