Forum Discussion
Filtering based on value in another table
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 🙂
5 Replies
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
Thanks - what should 'value' be in (Table2[value]) ?
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
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
Sorry no still not got the answer 😞
