Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Sorry no still not got the answer 😞
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
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |