Need help sorting a Matrix with images

[dkrid]

Hello,

   I need to create a matrix that shows overtime hours that each worker does in each day in a selected month. But instead of showing the OT hours as numbers, the matrix will show the OT hours as circles whose radius corresponds to the number of OT hours. (The more OT hours the worker does, the larger the circle). Here is what I've done so far - I use SVG to draw circles. (Here a month of April is selected so there are 30 columns (From 1 Apr to 30 Apr).)

But I want to also sort the matrix by the number of total OT hours each worker does in a month. FIrst I try to add a subtotal column and then sort that column. The problem is that the sorting order is incorrect. I hover a mouse over a circle and this is what I think is the culprit: The value of the data is not the total OT hours but the SVG code that I used to draw a circle.

But now I have no idea what I should do in order to sort the matrix by the number of total OT hours. Any suggestions?

[amitchandak · Accepted solution]

@dkrid , You can use isfiltered or isinscope and change measure from svg to value(at sub total/total level) and then sort on that

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

[dkrid]

I used isinscope per your suggestion. I ran into another problem regarding mixing svg and value but I fould a way to sidestep that problem. So now I can sort my matrix by the total OT hours. Thanks, Krid

[dkrid]

Thank you for the suggestion. Give me some time to digest the information - I am still quite new to Power BI. Best regards, Krid.