Forum Discussion
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 (...
Hello Anonymous ,
Try creating a table with DAX function TOPN .
I have a table called the city as follows:
Created a new table using TopN function as following :
Hope this helps.
VK
Hi Jpalji ,
Thanks for the response. I've looked into TOPN, but when I've attempted this function I get the top 5 issues for the year, and not for each week. I've done quite a bit of research and can't figure out how to make this function work for my week over week visual.