cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
myasirma Visitor
Visitor

Matrix values Decimal places issue

Hi,

 

In Power BI Desktop have a matrix and removed decimals from values by setting Data Type as "Whole Number" and Format as "General" and deciamal places as "Auto" which worked well but when published to Power BI service decimal values showing in report. Can someone have the clue to resolve the issue, snapshots attached for referencePowerBIDesktop.pngPowerBIService.png

2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: Matrix values Decimal places issue

Hi,

 

Try to change the decimal places as 0. I think Decimal Places AUTO will show 2 places.

I'm just giving an Idea.

 

garvicasas Regular Visitor
Regular Visitor

Re: Matrix values Decimal places issue

that was what i was thinking, changing decimals places to 0 it's better than converting to a whole number, since you are not losing information, and moreover it keeps this way when u "publish" it

2 REPLIES 2

Re: Matrix values Decimal places issue

Hi,

 

Try to change the decimal places as 0. I think Decimal Places AUTO will show 2 places.

I'm just giving an Idea.

 

garvicasas Regular Visitor
Regular Visitor

Re: Matrix values Decimal places issue

that was what i was thinking, changing decimals places to 0 it's better than converting to a whole number, since you are not losing information, and moreover it keeps this way when u "publish" it

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 1,787 guests
Please welcome our newest community members: