cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Format number in matrix without changing data model

Hi!

 

I have a matrix showing the average revenue per category. The revenue in my data model is formatted without any decimals. Still, in my matrix I get 2 decimals on my average.

 

How do I format this number in my matrix without changing my data model (cause that is not helping).

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Format number in matrix without changing data model


@Anonymous wrote:

Hi!

 

I have a matrix showing the average revenue per category. The revenue in my data model is formatted without any decimals. Still, in my matrix I get 2 decimals on my average.

 

How do I format this number in my matrix without changing my data model (cause that is not helping).

 

Thanks!


@Anonymous

You can try to format the measure by changing decimal places

 

Capture.PNG

View solution in original post

6 REPLIES 6
Highlighted
Microsoft
Microsoft

Re: Format number in matrix without changing data model


@Anonymous wrote:

Hi!

 

I have a matrix showing the average revenue per category. The revenue in my data model is formatted without any decimals. Still, in my matrix I get 2 decimals on my average.

 

How do I format this number in my matrix without changing my data model (cause that is not helping).

 

Thanks!


@Anonymous

You can try to format the measure by changing decimal places

 

Capture.PNG

View solution in original post

Highlighted
Anonymous
Not applicable

Re: Format number in matrix without changing data model

I cannot format any numbers. And in the data model is it already without decimals.

 

Capture.PNG

Highlighted
Anonymous
Not applicable

Re: Format number in matrix without changing data model

Im encountering the same issue. However, it seems when i duplicate the table or create a new table, and click on any area of the screen my formating appears!


Still in need of a proper solution

Highlighted
Regular Visitor

Re: Format number in matrix without changing data model

Click on the paint brush under visualizations, select data label, display units, change to None and 0 Decimal places.

Highlighted
New Member

Re: Format number in matrix without changing data model

I have this Same problem and the Format I am trying to change is NOT a measure, but the Summation Value of an actual Field [Value] from my query table. Despite the fact that the Field is defined as a whole number, the Value Summation in the MAtrix displays it as a a two digit Decimal Number.  The paint brush formatting tab allows you to change the font, font size, color, etc. of the the Value Parameter in the Matrix, but does not list number format as an editable parameter.  How can I edit the Sumation Value number format without the complication of defining a new measure, creating a new query, etc?

Highlighted
New Member

Re: Format number in matrix without changing data model

I had the same issue. You just need to select the data field in the Fields menu area (if this is a measure you will see the formula displayed too at the top) and this will unlock the format menu

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors