I want to create a heatmap that only applies to a specific row. While some have answered this question in the past, I am not seeing a clear cut way to do it.
I have Customer on the Y axis, Quarter on the X axis and measure is Shipment Quantity (only 5 quarters of data).
When I drop Shipment Quantity onto the Color Pill and make it a diverging Green to Red heatmap, it works across all shipments instead of at a customer level.
I know what i'm trying to do is possible, but could someone provide a step by step?
I have attached the superstore example, illustrating what I currently have set up in my workbook.
thanks in advance!