cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HenrikH29
Helper I
Helper I

Show values as whole thousands

Is there a way to format visuals or tables to have the numbers shown in whole thousands.

 

The object is to make it more readable ie. "1.234" instead of "1.234.123" as i have a large number of values in some matix visuals.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Ahh for a matrix, got ya.  For those i believe you'd have to write a measure that would convert the output for you.

 

Maybe something like:

Your Measure = ([Your Value] / 1000) & "K"

You could add rounding in here too.

 

View solution in original post

11 REPLIES 11
PeteD
New Member

In 2021 showing thousands or millions etc is now just a format option on the Matrix. The accepted solution involving making measures is now obsolete. Is there a way to flag out of date questions and answers?

calerof
Impactful Individual
Impactful Individual

Hi @PeteD ,

Not closed for me. If we're using a matrix to show a series of measures and improve performance, instead of using multiple single card visuals, then the measures appear without rounding. If we fix a rounding to display units in millions for example, then when we change the period from YTD to MTD the value may not reflect a useful amount, just $0.0M. This feature to change automatically doesn't exist, correct?

Regards,

Fernando

Agreed. The visual could show the data based on any value selected for a slicer. For eg. WW will have numbers in millions but looking at specific region/country through same visual, screws up the data labels.

I cannot find the option to format values as thousands in a Matrix.  Can someone post a screenshot of where that is?

 

calerof
Impactful Individual
Impactful Individual

Hi @NonnaBlue ,

Here:

data1.png

Regards,

Fernando

Anonymous
Not applicable

Yes, quite a lot of visuals allow you to do that.  Look under the "Format" section of the Visualisation Settings.  In there will be sections relating to the various displays.  What you are looking for is an option called "Display Units" and "Decimal Precision".  These are typically defaulted to "Auto", but you can set it to "Thousands" and 0

Yes i found that in other visuals however i cannot find it in the new Preview Matix visual (the one with drill down functionality).

 

I guess it's not an option in that.

 

Anonymous
Not applicable

Ahh for a matrix, got ya.  For those i believe you'd have to write a measure that would convert the output for you.

 

Maybe something like:

Your Measure = ([Your Value] / 1000) & "K"

You could add rounding in here too.

 

Answered my question Ross,  didnt even need to send you an email 🙂

 

Yes that was what i was "afraid of" .

 

I have a lot of values so i had hoped for a easier solution 🙂

 

Perhaps it will come as an option later...

Anonymous
Not applicable

I just tested this on a file i'm working on thats fairly sizable.  This was pretty fast:

Rev = 
VAR
	Result = round([Revenue] / 1000, 0)
RETURN

if(
	Result = 0,
	BLANK(),
	Result & "K"
)

*Note [Revenue] is a measure i'm using that is a sum of data.

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.