Memorable Membersaud968 Thank you! I still think there is an issue with filter contexts, let me explain:
When looking at the file, I'm looking at the "Single Column" page. For each 'Returned' card, I'm looking at the Reference Label - Detail field circled below, it's "Units Total Returned %"
The conditional format works - but it's simply showing Red. What if I want that detail value to only highlight Red when it's equal or over 24%? Rocky Mountains Return % should be Green at 19%, while every other small multiple should be Red. So, in that Reference Label, in that Detail Value, I change the formatting to be:
And similar to my issue, I get the following. The value is showing correctly for the small multiple filter context. Rocky Mountains small multiple is showing 19%, but the conditional formatting is still showing Pink, whereas I would expect it to show Green.
When I filter down to the Rocky Mountains small multiple, in the SAME visual, I get the following result:
So clearly the filter context works on the value - it always shows 19%. But the conditional formatting based on the value is NOT filtering down to the small multiple on the visual. I think this is a bug. If it's intentional, I would question what the point of having a conditional format formula on a reference label detail in a small multiple if it just calculates an aggregation and doesn't use the filter context of the small multiple.
Thoughts?
