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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
dlopesc04
Advocate I
Advocate I

Line chart and values flat after publishing pbix

This is how it looks in my machine:

 
 

dlopesc04_2-1710247701503.png

But in the published report it looks like this:

dlopesc04_3-1710247815940.png

 

What's up with those lines? Like, straight lines.
Here is the measure I'm using:


VAR ImpactoTotal = CALCULATE([Soma_Impacto],ALLSELECTED(TAB_BD_UNIFICADA13))
VAR TotalAnual = [Soma_Impacto]
VAR TbResumo =
SUMMARIZE(
ALLSELECTED(TAB_BD_UNIFICADA13),
TAB_BD_UNIFICADA13[Tipo/Conjunto],
"Total",[Soma_Impacto]
)
VAR TotalAcumulado =
SUMX(FILTER(TbResumo, [Total] >= TotalAnual),[Total])
RETURN TotalAcumulado/ImpactoTotal

it looks as a table in both scenarios:

dlopesc04_4-1710247975566.png

After publishing:

dlopesc04_5-1710248250530.png

Has anyone encountered this problem before? What is causing it and how to fix it?

 

 

2 REPLIES 2
dlopesc04
Advocate I
Advocate I

Hello @v-yohua-msft  ! This is the data from a month in the previous year (i.e something that is not changing anymore in updates).

Also, this happens just after publishing the report:
>save .pbix

>hit publish

>open in the Power BI Service
>and there it is in all its flat glory.

"After publishing, make sure to refresh the dataset in the Power BI service. If the data is not refreshed, it may not reflect the latest calculations or data, resulting in discrepancies."

I did again, instant flat line, then refreshed, flat line continued.

The Measure [Soma Impacto] is litterally just " =SUM(Table[Impacto]) "

v-yohua-msft
Community Support
Community Support

Hi, @dlopesc04 

 

Make sure that the data model and relationships in the Power BI Desktop file are set up correctly. Sometimes, differences in how the relationship between Desktop and services are interpreted can cause such problems.

 

After publishing, make sure to refresh the dataset in the Power BI service. If the data is not refreshed, it may not reflect the latest calculations or data, resulting in discrepancies. The measures you provide involve multiple variables and calculations. The context in which these calculations are performed can be slightly different between Desktop and the service. You can view the following documents:

 

Troubleshoot Power BI Desktop publishing - Power BI | Microsoft Learn

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.