cancel
Showing results for
Did you mean:
Highlighted
Helper V

## Percentage of total for each legend item

I am using a line visualization with multiple legend values. I want to show legends as a percentage of the total per month.

Now each legend value is displayed as a percentage of the whole.

For example, if the value for January is 2.78 % when I add a legend column which has values A, B, C the percentage is displayed as

A - 0,73 %

B- 1,71 %

C- 0,33 %, which is the percentage of the total

but I want to display it as

A- 26.4 %

B - 61.71 %

C- 11.89 %, which is the percentage of the total per month. each legend item should sum to ~100%

Is there a way to do this in a line chart?

Regards,

6 REPLIES 6
Highlighted
Super User IV

@Samrawit21 , try like

divide([measure], allexcept(Table, Table[month], Table[category]))

oe

divide([measure], allexcept(Table,  Table[category]))

https://youtu.be/6jTildcV2ho

Proud to be a Super User!

Highlighted
Community Support

Hi @Samrawit21,

Please share some dummy data with raw table structure, then we can do test coding formula on it.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted
Helper V

@v-shex-msft

I am using a line chart to display the distinct count of customers with multiple legend values. I want to show the count of customers as a percentage of the total per month.
Now each legend value is displayed as a percentage of the whole.
For example, if January had a percentage of value 2.78% when I added a legend column that has A, B, C values, the percentage is displayed as
A - 0.73%
B- 1.71%
C- 0.33%, which is the percentage of the total, but I want to show it like
A- 26.4%
B - 61.71%
C- 11.89%, which is the percentage of the total per month. each legend item must add to 100%
Is there a way to do this on a line chart?

I also want to add another line chart, which sums up legend values A and B.

Is this possible to do?

Below is my sample data.

Regards,

 Legend Customers YearMonth A 1212144 201904 C 8585899 201904 C 5858989 201904 A 9898877 201905 A 8989988 201905 C 8989999 201905 A 9999921 201904 A 2121212 201903 B 2121212 201904 B 1414121 201904 B 2221111 201903 C 4414141 201903 C 2121212 201903 C 7111212 201902 C 7777721 201904 C 8232323 201904 C 3333212 201902 B 2121233 201905 B 1241414 201905 A 1241414 201902 A 1212121 201902 B 4444455 201904 C 2121255 201902 B 4747777 201903
Highlighted
Community Support

Hi @Samrawit21,

Please check the below measure formula if it works on your side:

``````Measure =
DIVIDE (
CALCULATE (
COUNTA ( 'Table'[customers] ),
ALLSELECTED ( 'Table' ),
VALUES ( 'Table'[YearMonth] ),
VALUES ( 'Table'[Legend] )
),
CALCULATE ( COUNTA ( 'Table'[customers] ), ALLSELECTED ( 'Table' ) )
)
``````

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted
Helper V

I also want to add another line chart, which sums up legend values A and B.

Is this possible to do?

Highlighted
Community Support

Hi @Samrawit21,

Currently, you can't use the legend field and multiple value fields at the same time. Perhaps you can try to use R visual to manually plot the graph.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors