Workaround to use a measure as a slicer

[paultym]

Hi,

I have a measure that generates a percentage based on some rules. This is calculated in the section marked with 2, below. The section marked with 1 is for verification purposes. 

Depending on this percentage, a color is assigned to each result, in the last 2 measures in the image below.

Each possibility is calculated in a separate measure: Quadrant Color Blue, Quadrant Color Red, Quadrant Color Yellow, Quadrant Color Green, and then in the measure marked with 2 below, all these possibilities are concatenated.

The same logic is used to generate the text value of the color assigned to a specific percentage and the same logic is used to generate a HEX value of the color assigned to a specific percentage. 

I am using all these to create a scatter chart split in 4.

All these work fine and they are aligned on the chart where they are supposed to be.

The problem is that users need a slicer to filter by just one color. I tried various options to create a column based on the measures, like a disconnected table, switch statements, etc. and nothing seems to work. I either get incomplete values in the slicer or the slicer makes the table blank when used. I've also tried to use the parameter + slicer feature of powerbi and it does absolutely nothing when used.

Any suggestion is greatly appreciated. Thank you

[aj1973]

Hi @paultym 

Create Table and Rows then load it

Add a calculated column to your new table

Use the new Column from the new Table as a slicer to your visuals

[paultym]

Hi, thank you for your reply but i do not understand how this table is linked to the original data table. My table does not have a column with colors, but a measure. Please explain

[aj1973]

Hi,

I created a new Table with Column id numerical because thats what I need in my visual to be filtered. I linked the Column id of the new table to my master table via column id as well. That way when I add Color to the visual where there is id in the visual, the filtering by color works as I wanted.

For your exemple, I don't know what column in your visual that is coming from the master table therefore I can't give you the right exemple.

Maybe if you can share a sample of your PBIX I will help you better.

[paultym]

I see, my main table has millions of rows, i cannot manually connect to a hardcoded ID. thank you for your suggestion though 

[aj1973]

Millions of rows ! and manually connect to a hardcoded ID !

I don't think you understood my response and how you can apply it to your Model.

A Sample can be only with a table with 10 rows and couple encrypted columns. 

I invite to read this Manually Update Matrix table with forecast - Page 4 - Microsoft Fabric Community