Forum Discussion
Resolver IIConditional formatting logic keeps reverting back to percent/number
Hi leolapa_br , look how its easy when we interact with a dashboard, what you need is just edit interactions between any visual including treemap to filter your column chart.
Select treemap visual, go to format, click on edit interactions and in your column chart choose filter as shown bellow:
When i click in treemap value to filter, its now showing correct values.
Resolver IIThanks for taking the time Jai-Rathinavel.
I created the measure as directed and applied to the conditional formatting setup but unfortunately the issue persisted.
But that made me realize that the formatting is somehow 'stuck' to each respective month regardless of whether or not a filter is applied. Case in point, if you look at the first two screenshots I shared on my original posting you'll see on the first screenshot (no filter) that March, April and August are red and everything else are kept at the default color as they're supposed to be. However when the filter is applied (second screenshot) March, April and August are still red when March should've flipped to the default color, and January, May, June, July and October should've flipped to red but they were kept at the default color.
This leads me to believe that although a filter is applied the logic somehow still looks at the base measure as if no filter had been applied.
Super Userleolapa_br Are you showing current year months or months from all the available years ? Can you try filtering for one year and check the formatting?
- leolapa_br
Jai-Rathinavel the x-axis is the month column from the date/calendar table, so it's from all the available years.
Unfortunately the database only covers 2023 and 2024 sales data, so when I set the slicer to 2023 there will be no orange line on the chart since there is no 2022 data to calculate and compare against, therefore there's no way for me to check whether this formatting issue persists in prior years.