Broken visual in web service

[IanCockcroft]

Hi guys,

a report in dev is working 100%

as soon as i publish it and view it from the webservice, some visuals dont work.

I edited the report here and any visual using custom formulas was breaking.

I removed the formulars and the visual worked.

Any idea why?

[aj1973]

Hi @IanCockcroft 

I agree with @parry2k but let me add something that can be the cause: The version of your Power bi desktop is not up-to-date. Know that Power service is always Up-to-date and there is a new version for the desktop that comes out every month. 

Maybe you want to update your desktop

Regards 

[IanCockcroft]

Hi guys, not sure how I can exolain it better?

I did some more digging and hopefully      you guys know whats happening

in  the dev, a visual using a measure:

Percentage_Check-Ins = DISTINCTCOUNT(RMB_CheckIn_Data[employee_id])/COUNT(RMB_Employee_Details[employee_id])

when i publish it and view it, those visuals dont work.

Through trial and error, i worked out that the measure is breaking it. If i use another field or measure from the same table, it works.

AJ, updateing so long. will let you    know if thats the  issue.

thanks a mil

cheers

[v-zhenbw-msft]

Hi @IanCockcroft ,

Sorry for that we create a same measure like yours and publish it to Service, it works fine.

Maybe you can try DIVIDE function not use "/",

Measure = DIVIDE(DISTINCTCOUNT(RMB_CheckIn_Data[employee_id]), COUNT(RMB_Employee_Details[employee_id]))

If it doesn't work, maybe you can try to delete the card visual in Power BI Desktop and create it in Power BI service.

If you have any question, please kindly ask here and we will try to resolve it.

Best regards,

Community Support Team _ zhenbw

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

[parry2k]

@IanCockcroft sorry but nothing is clear from your post what you are referring too. Provide more context. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490