Please reference this topic for my problems. I tried more ways including filter the sale price >100000, but the median numbers do not change.
https://community.powerbi.com/t5/Desktop/The-Power-Bi-median-does-not-return-the-right-value/m-p/113...
This is the chart for the Great Sydney area's median price(the blue line) and the number of sold (the bar chart) for each year. The shared x-axis is the year number, a generated column from date of each row (= Table.AddColumn(#"Filtered Rows1", "Year", each Date.Year([sold_contract_date]), Int64.Type)). The data is from a government agency. It seems impossible the median prices are so "rounded"(900k,950k,1000k,1000k).
So I filtered the year 2019, used the "matrix" chart with the same other conditions, and export the one-column table (a .csv file) out. Then open with Excel, It has 4453 rows, and the median (2287th row) is 118300.
on:
Adding a measure or column as a tooltip to an Azur...
parry2k
on:
A Typo about Refence Line in the Format (Korean)
mattlee
on:
Automatically expand table columns to fill availab...