cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nwabramson
Advocate III
Advocate III

format distinct count

Is there a way to format the numeric result of an aggregation such as distinct count? I would like to add commas to my results and can't figure out how to display. 

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@nwabramson

 

A way yo solve your problem is:

 

If is only one value to show you can use a Card Visual. (In formatting Options you can made the changes to show the ,)

 

or Create a a measure to made the Distinct Count

 

Carrier-DC=DistinctCount(Table[Carrier]) And Formatting this measure (In modeling)




Lima - Peru

View solution in original post

8 REPLIES 8
Vvelarde
Community Champion
Community Champion

@nwabramson

 

Hi, you can model your field, column or measure going to Modeling Section:

 

Modeling.png




Lima - Peru

How do I model for a text field that I am creating a distinct count? I can't seem to figure it out for aggregates. 

If you go to the Data Label in the formatting, you can change the display units to none and the value decimal places to 0 the 1,000 comma appears in the result.

 

 

If you go to the formating options and look at the Data label field. If you change the Display units to 'None' and the Value decimal places from Auto to 0 then the 1000 comma separator is shown in the result. Found this by accident.

Sean
Community Champion
Community Champion

Take a look here

https://msdn.microsoft.com/en-us/library/ee634924.aspx

just be aware FORMAT converts everything to text

 

Hello - I do not know how to use the format command with a table that shows a distinct count of a text field.  I can't use the modeling format here either. I would like it to display 1,362 instead of 1362 .

 

format_distinct_count.PNG

 

Vvelarde
Community Champion
Community Champion

@nwabramson

 

A way yo solve your problem is:

 

If is only one value to show you can use a Card Visual. (In formatting Options you can made the changes to show the ,)

 

or Create a a measure to made the Distinct Count

 

Carrier-DC=DistinctCount(Table[Carrier]) And Formatting this measure (In modeling)




Lima - Peru

Thanks! That sounds like either way would solve my problem! Nancy.

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors