Forum Discussion

learner03's avatar
learner03
Icon for Post Partisan rankPost Partisan
3 years ago

Text Measure as legend in Pie chart

I have a table, through which it calculates Month's cover of Stock.  For this the user inputs the Number of Months as a variable  and I have used what if parameter for this. So, if user enters 3 , ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi learner03 ,

 

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]))

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

  • learner03's avatar
    learner03
    Icon for Post Partisan rankPost Partisan
    3 years ago

    Anonymous 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.