Creating a Slicer/Filter based on a Measure used for conditional formatting

[Anonymous]

Hi there,

I have a scatter map built on PowerBI with the colours of the marker being based on an independent measure 

Measure :

Color =

SWITCH(

TRUE(),

Currsales> Avgsales && Currev> Avgrev, "#0000FF",

Currsales< Avgsales && Currev> Avgrev, "#FFA500",

Currsales> Avgsales && Currev< Avgrev, "#FFC0CB",

Currsales< Avgsales && Currev< Avgrev, "#FF0000",

"#FFFFFF"

)

Scatter Map Values: Product Category (The original data doesnt aggregate the categories so I can't really apply the measure to the data itself)

The measure works perfectly. However, I'd like to know if it possible to build a slicer to filter the different coloured categories based on the measure.

Thank you in advance 🙂

[AllisonKennedy]

@Anonymous  This post is an awesome trick that creates a legend, but you can use the same technique to turn it into a slicer instead of legend: https://apexinsights.net/blog/include-legend-with-a-conditionally-formatted-chart 

[Anonymous]

Hi @AllisonKennedy ,

Thank you for your response! While the post is very insightful, there are some key differences that leave me a bit confused as to how to directly apply a similar approach for my case. Firstly, the scatter plot is based on a dataset which is not aggregated (unlike the dataset in the post that you've shared). Also, the scatter plot's X and Y values are also measures so creating a calculated table is rather tricky.  

[AllisonKennedy]

You don't need to create a calculated table, just need to manually input a table that has the values you want in the slicer. 

What options do you want the user to see in the slicer and where in your dataset do those come from?

These posts do similar technique, but will again have differences with your scenario: 

https://excelwithallison.blogspot.com/2020/06/dax-approximate-lookup.html

https://excelwithallison.blogspot.com/2021/09/power-bi-forecasting-with-irregular.html