Forum Discussion
Solved
Need help sorting a Matrix with images
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...
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 , 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/
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