cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tapaskaro Visitor
Visitor

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

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)

TopN_Report.jpg

 

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

 

Please provide your suggestion

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

Hi @tapaskaro ,

 

Did you try the TOP N filter ?

002.PNG

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
amitchandak Established Member
Established Member

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

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 

 

Community Support Team
Community Support Team

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

Hi @tapaskaro ,

 

Did you try the TOP N filter ?

002.PNG

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

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

Hi @tapaskaro 

 


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. 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 93 members 1,736 guests
Please welcome our newest community members: