filter out big data in charts

[drejko]

Hi,

I have data with weight, height and gender values. Unfortunately some weght data are wrong (in grams instead of kilograms). Is it possible to hide (filter out) this data so that chart will show correct / proper average value (e.g. 79 instead of 730 which shows now).

Thanks

[gipiluso]

you can filter it both in advanced editor or with a dax measure.

In the second case use this formula for measure:

CALCULATE(sum(Table1[weight]), FILTER(Table1,Table1[weight]<150))

in this case I assume max kg weight is 150kg

[drejko]

Is this meant like to create new column for data (and filter out undesired data) and work with it in visualisation?

I am totaly new with power bi and still finding my way with basics 🙂

[gipiluso · Accepted solution]

you can do both:

calculate a measure that exclude the weight > 150

or filter the table in advanced editor (edit query) remove the row completeley:

be aware that in the second case you remove the rows .

Another way is to replace the value in the advanced editor.

hope this help