cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Matrix - formatting column (Show value as >> Percent of column total)

hello,

My data is presented in a Matrix table.

Table has:

LOB, Vsl_type, Region, Revenue

LOB (lines of business)  is along rows.

Vsl_type and region are along columns

Revenue is the measure

+-----------+------------------------------+-------------------------------+

| Vsl_type>  |Vsl_type No. 1                       |  Vsl_type No. 2                     |

| LOB           | Atlantic  |Pacific |Operating  | Atlantic |Pacific  |Operating |

+-----------+----------|---------|---------- +---------|--------|------------+

| LOB1         |   38.25% |  2.31% |  0.85%     |   1.23% | 2.56% |    2.53%    |

| LOB2         |   18.15% |  3.23% |  1.18%     | 21.02% | 1.25% |   32.13%    |

| LOB3         |   23.05% |  1.03% |  3.22%     |  12.12%| 8.16% |   61.23%    |

|    :              |      :              :

|    :              |      :              :

+-----------+----------|---------|---------- +---------|--------|------------+

The perentages shown above are by dragging "Revenue" into the Values column and selecting "Sum"

The percentages are display by Right clicking the "Revenue" column and choosign "Show value as >> Percent of column total".

I've marked "Revenue" in Modeling as Data type: Whole number with 0 decimal places.

I am unable to find a way to format the Percentages to 0 decimal places.

Please can someone assist with this.

Rajesh

1 ACCEPTED SOLUTION
Microsoft Employee

@Rajesh1

Hi,

It seems there is no way to change it. It is already designed. But maybe there is a workaround. You could calculate the percentage directly with a measure. Then you can easily change the format. But you will have to change the measure every time you change the column field. The measure may look like this. Have a try please.

measure = Revenue/calculate(Revenue, allexcept('table', 'table'[Vsl_type>], 'table'[region])

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Microsoft Employee

@Rajesh1

Hi,

It seems there is no way to change it. It is already designed. But maybe there is a workaround. You could calculate the percentage directly with a measure. Then you can easily change the format. But you will have to change the measure every time you change the column field. The measure may look like this. Have a try please.

measure = Revenue/calculate(Revenue, allexcept('table', 'table'[Vsl_type>], 'table'[region])

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I

@v-jiascu-msft

Perfect! Thanks very much!

@v-jiascu-msft wrote:

@Rajesh1

Hi,

It seems there is no way to change it. It is already designed. But maybe there is a workaround. You could calculate the percentage directly with a measure. Then you can easily change the format. But you will have to change the measure every time you change the column field. The measure may look like this. Have a try please.

measure = Revenue/calculate(Revenue, allexcept('table', 'table'[Vsl_type>], 'table'[region])

Best Regards!

Dale

Microsoft Employee

@Rajesh1

My pleasure. I am so glad it can help.

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors