User Profile
oweism
New Member
Joined 10 years ago
User Widgets
Contributions
Re: Percentage-based KPI from SSAS Tabular model
Hi There, I have good news I was able to do it! First right click on your model and click view code. Then click ctrl + F and look for your measure name space goal for example for me it was [_Schedule Load Goal]. Once you reach the <calculationReference> XML tage add this line: <FormatString>'0.00 %;-0.00 %;0.00 %'</FormatString> Like here: <CalculationReference>[_Schedule Load Goal]</CalculationReference> <CalculationType>Member</CalculationType> <Visible>false</Visible> <FormatString>'0.00 %;-0.00 %;0.00 %'</FormatString> Please note that both the measure value and gola should have the exact same format for ppowerview to show them as percent. The format string above is for a percentage with 2 decimal points.2.4KViews1like1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.