Line Chart with a Legend value - show % from that period

[AliceW]

Hi fellow Power BI users,

This seems like a simple thing, but I can't get around to getting it done.

So, I have this basic Line-type chart:

- Axis: the date: Year, quarter, month, day.

- Legend: region.

- Value: amount.

If I select to 'Show value as % of grand total', it will display, say for January and EMEA, the % of EMEA of January from EMEA of the entire period.

What I'd like to display for each month (period) is the % of each Region: e.g., EMEA is 30%, APAC 50%, NA is 20%.

Any thoughts on how to make this happen?

I can do it in a pie chart, but I'd love to see the % evolution...

[simrantuli · Accepted solution]

Hi @AliceW,

For this requirement, you will need to create a calculated measure.

Let's say, below is your data.

Now, create a new measure as below:

And then, instead of taking the Amount as the value, take this newly created measure. Don't forget to set the Type of Measure as '%' as shown below.

Final output:

Best Regards

Simran Tuli

[AliceW]

Simran, thank you, this worked!!!

[amitchandak]

@AliceW , refer if this can help

https://community.powerbi.com/t5/Desktop/Showing-percentage-values-in-Stacked-Column-Chart/td-p/1697...

[AliceW]

Thank you, Amit!