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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dlopesc04
Helper II
Helper II

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
Helper II
Helper II

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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