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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
FelipeBR
New Member

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? Thank you in advance. Below is the formula for the measure shown on the card, the report on the power bi desktop and on the power bi service.

 

Formula:

FelipeBR_0-1658765360061.png

 

Visual on power bi desktop:

FelipeBR_1-1658765463884.png

 

Visual on power bi service after automatic data update:

FelipeBR_2-1658765529982.png

 

 

 

2 REPLIES 2
gauthamboppana
Solution Specialist
Solution Specialist

@FelipeBR  - Please refresh in desktop version and see if the KPI value is correct with the latrest data. There might some data issues in the latest data.

One suggestion, instead of muyltiple IF statements, can you change it to use Switch statement? Its easy to understand and debug.  Also, you may not need use concatenate in the calculation.

Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !

 

 

Did I answer your question? Please mark my reply as solution.

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. Look this to pictures above:

PowerBI Service report:

FelipeBR_0-1658776493321.png

PowerBI Desktop report:

FelipeBR_2-1658776979299.png

 

The KPI for the total is correct but the percentage doesn't work.

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors