Forum Discussion

Koy's avatar
Koy
Helper I
1 year ago
Solved

Card (New) not publishing (error fetching data)

I have a dashboard that was working fine until yesterday, and now when I publish and view in service the cards are no longer funtioning (works fine on DB, shows error in service).  I completely delet...
Need Help
  • Koy's avatar
    Koy
    1 year ago

    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.  
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Koy 

Based on my testing, the issue did not reproduce. Could you please provide a sample PBIX file that can reproduce the issue, as well as the version number of Power BI Desktop you are using?

 

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Koy's avatar
Koy
Helper I
1 year ago

Jayleny,
I have been able to recreate my issue with a dummy data set...
Table:  1_BPC 

Measures:  (NOTE the base measure NR does not specify a scenario that scenario AC and OL can be toggled between depending if we are looking at ACTUAL data or FORECAST)

NR = round(CALCULATE(  
    sumx('1_BPC', '1_BPC'[FIN_DATA]), '1_BPC'[PL_PLACEMENT]="NR")/[FX],0)  
NR LE = round(CALCULATE(  
    sumx('1_BPC', '1_BPC'[FIN_DATA]), '1_BPC'[PL_PLACEMENT]="NR", '1_BPC'[Scenario]="LE")/[FX],0)  
NR BP = round(CALCULATE(  
    sumx('1_BPC', '1_BPC'[FIN_DATA]), '1_BPC'[PL_PLACEMENT]="NR", '1_BPC'[Scenario]="BP")/[FX],0)  
NR PY = round(CALCULATE(  
    sumx('1_BPC', '1_BPC'[FIN_DATA]), '1_BPC'[PL_PLACEMENT]="NR", '1_BPC'[Scenario]="PY")/[FX],0)  
NR v PY = Round(([NR]-[NR LE]),0)
NR v PY = Round(([NR]-[NR BP]),0)
NR v PY = Round(([NR]-[NR PY]),0)
NR vs LE Indicator =

if([NR v LE]>0,UNICHAR(9650),if([NR v LE]<0,UNICHAR(9660),UNICHAR(9640)))
 
FX = 1.25
 
With that I built a basic CARD(new) and that appears to render in SERVICE
I then added a CARD(NEW) with more formatting.   Rounded corners, accent bar, etc.  That still seems to work fine with one EXCEPTION...  If I have NR v LE in the detail field, the card will not work in service.  HOWEVER, I can have NR v BP and NR v PY as details and it works just fine. 
 
DESKTOP:

 


 

SERVICE

 

  • Koy's avatar
    Koy
    Helper I
    1 year ago

    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...

     

    • Koy's avatar
      Koy
      Helper I
      1 year ago

      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.