Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

0

Measure does not show correct value after updating data in power bi service

I created a report in power bi desktop and published it in power bi service. All values and graphics were correct. After the first automatic update of the report data on the power bi service, one of the cards stopped showing the value correctly. Can anyone help me to solve this problem? Below is the formula for the measure shown on the card, the report on the power bi desktop and on the power bi service.

 

FelipeBR_0-1659095914145.png

 

Visual on power bi desktop:

 

FelipeBR_2-1659095965433.png

 

Visual on power bi service after automatic data update:

 

FelipeBR_3-1659096123904.png

 

As showed above the KPI for the total is correct but the percentage doesn't work. Both data are update. Even the problem only starts when after I publish the report, its dataset is updated in the powerbi service, causing the information of this KPI to be lost. I didn't understand why this is happening. Thank you in advance.

Status: Delivered

Glad to hear that this issue could be resovled by changing the type and this issue will be closed.

 

Best Regards,
Community Support Team _ Yingjie Li

Comments
v-yingjl
Community Support
Status changed to: Investigating

Seems like could not reproduce it in my side as far as my test.

Did this issue happen in all workspaces or have you tried to republish this report to different workspaces to check this issue again?

If it still has the same issue, you can consider sharing a sample test file without any sentive information which could reproduce this issue.

 

Best Regards,
Community Support Team _ Yingjie Li

FelipeBR
New Member

Hello @v-yingjl ,

 

I was able to solve this issue change the type of some collumns in the data. Thank for your help.

 

Best Regards,

@FelipeBR 

v-yingjl
Community Support
Status changed to: Delivered

Glad to hear that this issue could be resovled by changing the type and this issue will be closed.

 

Best Regards,
Community Support Team _ Yingjie Li