Forum Discussion

wmtan01's avatar
wmtan01
New Member
4 years ago

Filtered data in graph

Hi!   I'm very new to Power BI and managing our reports. Long story short, we have data tables that contains metrics. Since the readings can be erratic we remove the outliers before using the data....
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi wmtan01 ,

 

Not very clear, can you please share more detail information to help us clarify your scenario?

If you wan to calculate the average, please use AVERAGE().

 

Best Regards,
Eyelyn Qin

  • wmtan01's avatar
    wmtan01
    New Member
    4 years ago

    Hi,

     

    What we needed was to remove outliers on each column and not have it affect the other columns. Looking around, Trimmed Mean was the one we've decided to use, it allowed us to remove a certain % of data that are highest and lowest values then average the remaining ones. Before we were doing normal Average but before we pulled the data to PowerBI we were removing rows and rows of data with outliers. I was looking for a way to minimize the manual steps we were doing.