Is it something like this? if yes, please find my solution attached.
Make sure your filter is add to context. (right click filter and select add to context)
Hope this helps
Maternity Leave_v10.4.twbx 23.4 KB
you can use an lod
and then the color code is
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Maternity Leave_v10.2.twbx 25.2 KB