Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Weekly Top 5

Hello,   Fairly new to BI and I have built a YTD, weekly, column chart that displays our customer service teams top case issues, per category. When I filter the "Issues" to only display the top 5 (...
Need Help
Show and Tell
Tutorial Requests
lc_finance's avatar
lc_finance
Solution Sage
6 years ago

Hi Anonymous ,

 

 

the solution would be to filter the table for calculating the top 5 issues per week.

You can filter a table either using FILTER or using CALCULATE.

 

Are you able to share a Power BI sample file? (of course not with real data, but sample data)

I'd need to take a look at your PBI file to better understand your model and provide you with more help.

 

Regards

 

LC 

Interested in Power BI and DAX tutorials? Check out my blog at www.finance-bi.com

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi lc_finance ,

 

Thank you for the response. I have attached a snippet of a table I built. I hope this give you an idea of how our data model is being built. I am currently using a calculate measure to try and pull my top 5 per week, however, the issue I have currently is that it will only show the top 5 for the year. The only way I can see the top 5 per week is by using a Slicer and pulling it week by week, but I need to see it week over week as shown in my previous post. 

 

Sample Data: I'm pulling thousands of cases and trying to pull top 5 issues per category, per week.

 

Individual week pulled for a category.

  • lc_finance's avatar
    lc_finance
    Solution Sage
    6 years ago

    Thank you Anonymous  for your reply.

     

    To help you further, could you share a sample Power BI file?

    That would make it a lot easier to understand the issue and help you.

     

    Regards

     

    LC

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi lc_finance ,

       

      I'm unable to share files from my one drive at work (internal only) and I don't have access to dropbox for file sharing. It doesn't look like I have a file attachment option within the forum either. 

      • lc_finance's avatar
        lc_finance
        Solution Sage
        6 years ago

        Hi Anonymous ,

         

         

        you are right, there is no option for file sharing in the blog.

        However, creating a One Drive or Google Drive account should be free if you want to try that way.

         

        Regards

         

        LC