Visualization Card Rounds Value, Need Exact Number From Excel source

[thebigbamf]

I am working on a dashboard and would like an exact value from the sheet but it rounds.

SOURCE:  Employees put in KPI metrics into an excel spreadsheet on Sharepoint.  I use Power BI to injest the excel spreadsheet.

DATA:

MEASURE CODE:

Monthly Telecom Uptime = LASTNONBLANKVALUE(Telecom[Date],sum(Telecom[Telecom % Telecom Uptime]))

OUTPUT:

What I would like to see (I dont care if it has a % after it or not I can put it in the title) is an easy way to fix this so it shows the 99.999 Uptime instead of rounding to 100.

I have tried to change the visualization on the card from AUTO to NONE under Display Units as well as modified the value decimal place and that did not change anything but add the decimal places.

Any help would be greatly appreciated!  Thank you!

[TheoC · Accepted solution]

@thebigbamf  in the visual pane settings, you can go to the value and increase the number of decimal places you want in the visual.  Just set it to 4, 5 or whatever the decimal values go to.

[thebigbamf]

Thank you!  I had it set to 2, but once I put it to 4 or 5 it broke it out. 

[TheoC]

@thebigbamf  good to know it worked mate!