I have a scenario where I have written a measure to calculate the % consumption of stock with respect to the total available stock over the current month and future months.
Used that in a matriX w.r.t to Products and Month-yy and created a heat map.
The problem here is with normal condition formatting it is considering all the products across all the months and assigning the color pattern
What I require is it should compare row-wise only for that particular product across the month and based on the month-wise highest and lowest coverage should provide the color scheme.
Thanks in advance.