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.
This is how it looks in my machine:
But in the published report it looks like this:
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:
After publishing:
Has anyone encountered this problem before? What is causing it and how to fix it?
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]) "
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
97 | |
85 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |