Power BI Matrix visual - whole number and decimal for a value column

[Anonymous]

On Power BI matrix visual, how do I list down the value in both whole number and decimal at the same time?

This is what I want to achieve:

Work	Man Hour (hours)
Task A	10
Task B	8.5
Task C	9

I have tried on the Field formatting -> Value Decimal Places

if i put 0, it will round up the decimal value to whole number 10, 9, 9

if I put 1, it will give 10.0, 8.5, 9.0

[Jihwan_Kim · Accepted solution]

I suggest creating it in the Tabular Editor in Power BI Desktop.

https://www.dropbox.com/s/gwaoum4ycaxaox9/mikeKK.pbix?dl=0 

[Anonymous · Accepted solution]

I also realized in the Model page,  by selecting "Custom" as the format, and select "General Number" as the custom format can give the desired result.

      

[Anonymous]

HI @Anonymous,

AFAIK, current power does not support you to set multiple formats in one field. Perhaps you can use the format function to convert your values to text and keeping special formats.

In addition, you can also take a look at Jihwan_Kim 's suggestion to directly change them in the data model side if helps.

External tools in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng

[Jihwan_Kim · Accepted solution]

I suggest creating it in the Tabular Editor in Power BI Desktop.

https://www.dropbox.com/s/gwaoum4ycaxaox9/mikeKK.pbix?dl=0 

[Anonymous]

Sorry I overlook this for awhile.  The idea is to change the number to text format right?

[Jihwan_Kim]

The number is still the number.

Inside Tabular Editor in Power BI, for instance, the author can assign Type1 numbers to show one decimal, Type2 numbers to show zero decimal, Type3 numbers to show two decimal.

[Anonymous]

Thank you for the solution