Forum Discussion
PowerBi Desktop data refresh and export to PDF
What will happen if you interact with the retained values?
We don’t interact with retained values – this is a scorecard and after refresh just needs to be published to business stakeholders using PDF exports.
Which version of the Desktop do you have?
2.65.5313.1381 64-bit (December, 2018)
Which visuals? Are they custom visuals?
We are not using any custom visuals – we are using all PBI pre-packaged visuals (tables, matrix and graphs/line chart) all of them have issue.
Could you make it more clear, please? Location level parameter is used to calculate most of the measure against this data source. I'm afraid we can't use a parameter in a measure. Maybe you did something else.
We use input parameters to build measures using DAX.
Find below example of one of the measures – it is using 2 parameters (snapshotDate and SiteLocation) to calculate MTD revenue based on SiteLocation
MTDRevenue = CALCULATE(SUM('MeasureAggregatedGL'[MTDAmount]),FILTER(MeasureAggregatedGL,MeasureAggregatedGL[Lineage]="Actual"),FILTER(SitePnL,SitePnL[GLHierarchyCatDesc - Copy.2]<>"OtherIncome"),FILTER(ALL(SitePnL[GLHierarchyCatDesc]),SEARCH("Revenue_",SitePnL[GLHierarchyCatDesc],1,0)>0),FILTER('MeasureAggregatedGL',MeasureAggregatedGL[SiteLocationDim.Site]=SELECTEDVALUE(SiteLocation[SiteLocation])),FILTER(MeasureAggregatedGL,MeasureAggregatedGL[Date.End of Month].[Date]=SELECTEDVALUE(SnapshotDate[SnapshotDate])))
Hi Anonymous ,
What my first question do is to check if the data is correct before exporting.
I would suggest you file a support ticket here. It seems fine in my test that is based on your description.
Best Regards,