Forum Discussion

admiralman's avatar
admiralman
Icon for Advocate II rankAdvocate II
8 years ago

Dynamic Weighted Average

I am trying to get the Average Price per month similar to the following. The average needs to change based upon the selection of the Location and Model slicers. Ultimately I need to be able to graph ...
Need Help
admiralman's avatar
admiralman
Icon for Advocate II rankAdvocate II
8 years ago

v-juanli-msftI have updated this post becuase what I thought didn't work in the solution seems to work fine. However, the key is that I am going to want to be able to put this in a chart and graph by month with a totla price per month...not by model. When I select multiple months this does not seem to work.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi admiralman

put this in a chart and graph by month with a totla price per month...not by model

Does this chart meet your goals?

 

When I select multiple months this does not seem to work.

What do you want to show when you select multiple months?

 

Best Regards

Maggie