Hello Everybody,
I think i'm in a cul de sac.
I have been trying in last 3 hours to filter my Power Bi Tile on my app using two combobox.
The filter works on one of them; however, when cant use the function concat on the other one to filter several values from the field (power bi), it's not working. I have tried without the concat function an just with the URL?filter=Table/Field in ('value1', 'value2') and it's not working. I double checked the table and field used, but i can't find where is the error.
For information, my Power Bi is linked to a Sharepoint with a flow that refresh the Power Bi once the sharepoint is modified. The values i want to filter are text values from the sharepoint and present in the Power Bi.
The code i used to filter the URL on Power App:
"https://app.powerbi.com/embed?dashboardId=2dda053d-8643-4612-b3be-410b3e200353&tileId=0024a961-6a08-48f0-98ec-c30efd7dde06&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLVdFU1QtRVVST1BFLUItUFJJTUFSWS1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldCIsImVtYmVkRmVhdHVyZXMiOnt9fQ%3d%3d" &
If(
// RULE 1: No filters
CountRows('Companies-Combobox'.SelectedItems) = 0 &&
CountRows('BusinessUnit-Combobox'.SelectedItems) = 0,
"",
// RULE 2: Companies selected (priority)
CountRows('Companies-Combobox'.SelectedItems) > 0,
"&$filter=Engagement2/IssuerName in (" &
Concat(
'Companies-Combobox'.SelectedItems,
"'" & Value & "'",
","
),
// RULE 3: Business Unit only
"&$filter=Engagement2/BusinessUnit eq '" &
'BusinessUnit-Combobox'.Selected.Value & "'"
)
Name of my table:
My Field present in the Power Bi Report:
When the Report is filtered with AXA:
My Power App:
When filtered with AXA:
When filtered using the Business Unit combobox:
Thank you for your help !
