Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi group, I have a requirement where I have to color the bar based on dimension value picking from another field which is working fine. But when other field selections are made, this condition doesn't work.
Based on the data model, I am attaching a sample dashboard here. Anyone faced similar issue?
Based on your model, Customer #2 isn't associated with any Report Number. So If you select a report number, lets say 1, the Customer Name 2 is null.
Your color expression:
=if(Only({<[Report Number]=>}[Customer Name])=Only([Customer Name 2]), Green(), Red())
Customer Name: Cust1
Report Number: 1
Customer Name: null
Cust1 <> null thus output is Red()
The 2nd part of your condition should also ignore the Report Number selection then it will not change.
=if(Only({<[Report Number]=>}[Customer Name])=Only({<[Report Number]=>}[Customer Name 2]), Green(), Red())
Did the partner post assist you in getting things working? If so, do not forget to return to your thread to close things out by using the Accept as Solution button on that post to give them credit for the help and let other Members know that worked. If you are still working on things, please leave an update with what you still need from us.
Regards,
Brett