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

[Rajesh1]

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.

Thanks in advance.

Rajesh

[v-jiascu-msft · Accepted solution]

@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

[Rajesh1]

@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

---

[v-jiascu-msft]

@Rajesh1

My pleasure. I am so glad it can help.

Best Regards!

Dale