Forum Discussion
Card (New) not publishing (error fetching data)
I think what you were missing here was conditional format on the reference labels. I found that when that conditional format was the same as the format on the Accent bar it would not publish correctly.
My solution was to create a new measure that determined the color.
IND LE Color = Switch(True(),[ACvsLE]<0,"#FF0000",[ACvsLE]=0,"#e56e1d",[ACvsLE]>0,"#59a33a")In the conditional formatting of my refernece labels, I used Field Value and selected the new color measure. That solved all my publishing issues.
I have also tried to do this without using an FX conversion factor and issue persists. I thought that might be the issue originally as my volume vs LE is showing but my $$ vs LE will not. Just another wrinkle...
Forgot to add... Accent bar highlighting... Rule based conditional formatting on NR v LE
NR <= 0 is red
=0 is yellow
>0 is green
I just changed my boxes to have conditional formatting and it breaks and works when I remove the accent bar. If the accent bar is testing the same measure as diusplayed in the Detail value, the error fetching data occurs.