Forum Discussion
Price Change Filter
Microsoft EmployeeI would think the best approach here would be to have a table with incremental values, say "0.5%", "1%", "1.5%" etc. up to some limit, and use this as a slicer. Simultaneously, add a calc column to the original data that determines the price change (or if it comes from the data source) and then add another calc column for the percentage bucket. Those buckets would mirror the buckets you made in the first table, and then you can build a relationship and use the slicer in the report.
So now that I am mulling this over, if the filter had values of "0.5%", "1%", "1.5%" etc....what would happen if any of the changes are not exactly "0.5%", "1%", "1.5%" etc. For instance my fear is if a results was a 1.15% change, would the filter exclude those items since there is not matching filter value? Thoughts?