Forum Discussion

SteveIOW's avatar
SteveIOW
Icon for Helper II rankHelper II
4 years ago

Average of DistinctCount PCM

Dear all,   as you can see below I am trying to find the average of the last 6 months data. The data is loaded in as individual users and the date the access a website. I am countinf the number th...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, SteveIOW 

You can try to add dynamic reference lines to visuals with the Analytics pane in Power BI Desktop.

Please select visual->go to Visualization Area -> Analytics -> Average Line 

Use the Analytics pane in Power BI Desktop 

 

Best Regards,
Community Support Team _ Eason

SteveIOW's avatar
SteveIOW
Icon for Helper II rankHelper II
4 years ago

Thank you - my issue is that I am trying to create an SPC that rferences only the last 6 months for mean and sigma lines. the rference line visuals will only provide mean and sigma lines for the whole displayed data. I need it to display the lines across the whole data but using only the last 6 months in the calculation.

any ideas?