Text Measure as legend in Pie chart

Question

I have a table, through which it calculates Month's cover of Stock.&nbsp;
For this the user inputs the Number of Months as a variable&nbsp; and I have used what if parameter for this. So, if user enters 3 , it calculates sum of last 3 months of sales and&nbsp; divide current stock on hand by the sum of last 3 months sales&nbsp; to give Number of month's cover.
Now I need to create Pie chart of&nbsp; this depending on the Month's cover calculation. So if the answer is between 0-5 then pie chart slice is green, if month's cover is 6-10 then yellow and above that it should be red..
&nbsp;
All my month's cover, sum of sales are measures. I can't get how to make a legend on pie chart based on 0-5,6-10 and greater that 10 for this.
&nbsp;

vicky_ · Answer

I don't think you can use measures in the legend. But you can create a measure for each of the groups and add each measure to the Values section.

learner03 · Answer

vicky_&nbsp;Can you provide me with an example please

anonymous · Answer

Hi&nbsp;learner03&nbsp;,
&nbsp;
Here's a possible idea.
You can create a seperate table for the range.

Use the SWITCH function to judge the different results of fan'h.
Measure = SWITCH(MAX('Table (2)'[Legend]),"0-5",[Expression1],"6-10",[Expression2]))

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

learner03 · Answer

Anonymous&nbsp;I used this approach from one of the videos and could create the chart, but there is a table underneath it which has details about items associated with customers. I also have slicers to select customers. The working should be when I click on a particular slice of pie chart, the data should be filtered or other ay around,when I click on particular slicer filter for customer the pie chart should change. This link is not happening as I do not have common column to connect.

nil · Answer

Hi there,Have you got the solution?I am having the same issueThank you

Forum Discussion

Text Measure as legend in Pie chart

7 Replies

Related content

Clustered column chart incomplete legend

Legend Format for Line Column Chart

Line chart with Legend and additional measure

Previous Year Measure for Line Chart

Power BI Clustered Column Chart Legend Behaviour