topic Re: Ribbon Chart in DAX Commands and Tips

Ribbon Chart

ccianci — Thu, 13 Apr 2023 17:12:44 GMT

I have a column of "subcategories" for service desk ticket details. I need to show the top 3 subcategories over the last x weeks. I used a ribbon chart which was great but i quickly realized it doesnt show me the top 3 for each week but rather the top 3 based on the total sum over x weeks. For exampe, one subcategory was #2 for the week but over the course of a 4 week period, it's not in the top 3 so the ribbon chart omits that category completely. So based on that, I would miss that detail during my report.

is there a way to show the top 3 for each week individually? I know I can use a matrix or table but is there a better visual I can use?

Re: Ribbon Chart

FreemanZ — Thu, 13 Apr 2023 22:23:28 GMT

hi ccianci

what context do you have for the ribbon chart? could you make a screenshot?

Re: Ribbon Chart

ccianci — Fri, 14 Apr 2023 11:52:41 GMT

Here's a screenshot. First image is the matrix view and the 2nd image is the same data in a ribbon chart.

I highlighted (in yellow) the top 3, which is because over the 4 week period, the sum of those 3 are the highest and that makes sense why the ribbon would show those 3. The problem is where I highlighted in red. Week 12 has "hardware" surpassing "software/applications" but it's not in the top 3 because of the overall sum is less than the others.

for further context:

x-axis is "year & week"

y-axis is "count of subcategory"

legend is "subcategory"