Filtering based on value in another table

[FlowViz]

Hi guys,

I need your help with one of my visuals 🙂

I have this chart that has a dot for each item. Some of these items may be 'blocked' so I want to add a way to highlight those (in red):

There is a similar (but the same) table in my dataset that has a column for this:

However I don't have this column in my table being used for the visual (for performance purposes):

Is there anyway I can get the blocked items highlighted in the table being used for the visual?

I have added the file here for those who could help 🙂

[FlowViz]

Sorry no still not got the answer 😞

[v-shex-msft]

Hi @FlowViz,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[FlowViz]

Thanks - what should 'value' be in (Table2[value]) ?

[v-shex-msft]

Hi @FlowViz,

According to your description, I think you can remove the legend fields and set data color with conditional formatting to achieve your requirement.

Expression-based formatting - Release Notes | Microsoft Docs
Regads,

Xiaoxin Sheng

[amitchandak]

@FlowViz , Try a measure like

measure =
var _tab = summarize(filter(Table1, Table1[blocked2] ="Y"),[workitemdid2])
return
calculate(count(Table2[value]), filter(Table2, Table2[workitemdid] in_tab))

or try to use

https://docs.microsoft.com/en-us/dax/treatas-function