Hi all,
Has anyone tried to filter PowerBI tile and filter with multiple conditions?
Tried the following and it doesnt work:
Filter Condition:
&$filter=BOOKINGS/ResourceType eq '"&cmbFacility.Selected.Value&"'" And
&$filter=BOOKINGS/Status eq '"&cmbFacility2.Selected.Value&"'"
Appreciate if anyone can share insight on how to overcome it.
Thanks in advance!
Regards
Hidayat
Solved! Go to Solution.
You should only use &$filter once like this:
&$filter=BOOKINGS/ResourceType eq '"&cmbFacility.Selected.Value&"' and
BOOKINGS/Status eq '"&cmbFacility2.Selected.Value&"'"
You should only use &$filter once like this:
&$filter=BOOKINGS/ResourceType eq '"&cmbFacility.Selected.Value&"' and
BOOKINGS/Status eq '"&cmbFacility2.Selected.Value&"'"
User | Count |
---|---|
256 | |
106 | |
92 | |
47 | |
37 |