Forum Discussion
Solved
Measure as Filter (Alternative)
I have table of sales by sales points. I am showing every sales point on a map. I want to see all sales points where sales droped or all sales points where sales increased.
I have created a measure which calculates difference in sales from the previous month and than I have created a measure which gives me Sales Drop True/False to use it as a filter. But than I found out that measures can't be used as a filter or legend on a map.
Is there any alternative to achieve this?
- Try adding the sales difference measure to the Color Saturation area of the field well for the map. Then, in the formatting pane you can set the colors so that positive values are one color and negative values are another. You can also then use the Visual Level Filters.
2 Replies
- Try adding the sales difference measure to the Color Saturation area of the field well for the map. Then, in the formatting pane you can set the colors so that positive values are one color and negative values are another. You can also then use the Visual Level Filters.
Thank you, that is exactly what I needed!
