Forum Discussion
Deneb heatmap color tweak
Apologies but workplace security policies and practices prevent me from uploading a pbix, etc. I have a Deneb spec that I am reusing that, thanks to earlier contributions from giammariam , is al...
Thanks for the response, lbendlin. Here is some sample data:
| Category | Date | Change |
| Category 1 | 9/1/2022 | 26% |
| Category 1 | 10/1/2022 | 35% |
| Category 1 | 11/1/2022 | 25% |
| Category 1 | 12/1/2022 | 30% |
| Category 1 | 1/1/2023 | 22% |
| Category 1 | 2/1/2023 | 32% |
| Category 1 | 3/1/2023 | 48% |
| Category 1 | 4/1/2023 | 35% |
| Category 1 | 5/1/2023 | 36% |
| Category 1 | 6/1/2023 | 34% |
| Category 1 | 7/1/2023 | 28% |
| Category 1 | 8/1/2023 | 24% |
| Category 1 | 9/1/2023 | 16% |
| Category 1 | 10/1/2023 | 44% |
| Category 1 | 11/1/2023 | 32% |
| Category 1 | 12/1/2023 | 31% |
| Category 1 | 1/1/2024 | 34% |
| Category 1 | 2/1/2024 | 215% |
| Category 1 | 3/1/2024 | 29% |
| Category 2 | 9/1/2022 | 27% |
| Category 2 | 10/1/2022 | 23% |
| Category 2 | 11/1/2022 | 26% |
| Category 2 | 12/1/2022 | 26% |
| Category 2 | 1/1/2023 | 29% |
| Category 2 | 2/1/2023 | 23% |
| Category 2 | 3/1/2023 | 15% |
| Category 2 | 4/1/2023 | 21% |
| Category 2 | 5/1/2023 | 26% |
| Category 2 | 6/1/2023 | -17% |
| Category 2 | 7/1/2023 | 30% |
| Category 2 | 8/1/2023 | 27% |
| Category 2 | 9/1/2023 | 26% |
| Category 2 | 10/1/2023 | 29% |
| Category 2 | 11/1/2023 | 25% |
| Category 2 | 12/1/2023 | 24% |
| Category 2 | 1/1/2024 | 22% |
| Category 2 | 2/1/2024 | 24% |
| Category 2 | 3/1/2024 | 16% |
Here's how the matrix would look like based on your sample data.
Thanks, lbendlin . This could possibly work, although my stakeholders are used to seeing the Deneb version and change is hard. I can't get the DAX to work, though. Maybe because "Change" in my data set is a DAX expression and not a column?
Please provide sample data that fully covers your issue.