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
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