How to display two measures in a pie chart with legend

[Anonymous]

I'm developing a pie chart and on it I have a dimenssão and two measures one that shows the percentage compared to the total of the values of other measures, for example, total sales per store and the percentage of each store referring to the total sales.

It is necessary to present the values of the two measures but the maximum I can do however have two measures in the chart is to display one of the two measures

In the image below is the chart with only one measure

in the chart below is the same graph two measures

I would like to stay

I would like to position the values of a measure next to the legend

note: this chart I need to apply a top 10 rating

two measures that I am using

Top 10% Purchase Order Suppliers RANKX = (ALL (DMEGF_Fornecedor [Provider]); CALCULATE (SUM (Facts [Vl_PedidoCompra])))

Purchase Order Total = sum (Facts [Vl_PedidoCompra])

[v-caliao-msft · Accepted solution]

Hi Vitexo87,

According to your description, you need to display two measures in a pie chart with legend, right?

Based on my research, we can only modify Legend position, title, colr and text size. So display another measure into legend is not supported is current version of Power BI desktop. To work around this issue, you can turn off the legend for your pie chart, and use a table beside the pie chart, and display another measure on that table.

Regards,

Charlie Liao

[asocorro]

Legends cannot display values but you could have a separate char tto simulate that.

On another note, I would stay away from pie charts: https://www.perceptualedge.com/articles/visual_business_intelligence/save_the_pies_for_dessert.pdf

[Sean]

@Anonymous Create a Table and add these 3 items

1) add the Provider field => DMEGF[Provider]

2) then the Purchase Order Total = sum (Facts [Vl_PedidoCompra])

3) and lastly Top 10% Purchase Order Suppliers RANKX = (ALL (DMEGF_Fornecedor [Provider]); CALCULATE (SUM (Facts [Vl_PedidoCompra])))

4) go to Visual Level Filters and select is less than or equal to 2

[Anonymous]

@Sean

after you have done this as it was set the values in the pie chart?

[Sean]

@Anonymous I'm not sure what you mean? I tested it...