Forum Discussion
URL filter parameter data with specific values in param for page?
Hello Team,
I have to filter the application name in the screen based on the url param filter with user 'UUID' value of the each individual user, when accesing the url in the browser, Applications liked to the user need to be filtered in the 'Slicer List' as shown in the image.
When i am accessing the below URL in the browser it should filter and display only the mappings related to the 'traces_user' - user (UUID) column value. Nothing but each user has individual UUID and while accessing it has to display onl y their application names in the "Sllicer" list left side of the screen.
https://app.powerbi.com/groups/b0177797-7194-4fb4-8819-811a24bd2c63/reports/a5p8d9d8-0dd0-397a-8bec-80012d4frrt2/ReportSection2e42f592a0d6390d55a0?filter=traces_users/user in ('adf7eef0-133c-4eb4-8900-93fcf398a84c')
Is it possible or not via UUID based on mapping in Model View?
When i use application name and appid with corresponding table then it works for me. Below one works,
https://app.powerbi.com/groups/b0177797-7194-4fb4-8819-811a24bd2c63/reports/a5p8d9d8-0dd0-397a-8bec-80012d4frrt2/ReportSection2e42f592a0d6390d55a0?filter=traces_latestdateapps/appId in (9,23,92,110,123,145,165,1312,1313)
Thank you,
Siva
Hi. Make sure the filter is working putting your mouse over the head icon of a visual and check its filters. I would check because I don't see the user name at the trace_user table and the table is not propagating any filter through the data model. Filtering UUID will only change user, id and appid from that table. Nothing else.
The URL built for this looks right. I would only considering using operator "eq" instead of "in" if the value to check is only one. Try that change for eq and check the data model.
I hope that helps,
6 Replies
Hi. Make sure the filter is working putting your mouse over the head icon of a visual and check its filters. I would check because I don't see the user name at the trace_user table and the table is not propagating any filter through the data model. Filtering UUID will only change user, id and appid from that table. Nothing else.
The URL built for this looks right. I would only considering using operator "eq" instead of "in" if the value to check is only one. Try that change for eq and check the data model.
I hope that helps,
Hi ibarrau ,
Thank you for your reply.
I don't see the user name at the trace_user table.
-- In the 'traces_user' table there is column name called ' user' available as per the previous thread.
table is not propagating any filter through the data model. Filtering UUID will only change user, id and appid from that table.
-- For this in 'Model View' i have modified the cross filter direction to ' both' for all the mappings(3 tables, 2 relation ship).
Its working now for me , It filters only the application which is mapped to the user column in traces_date table application ids.
Thanks,
Siva
Hi. I'm glad you work it around with the reply.
Just for future improvements, you can manage the filter direction in the measures to prevent the both for the whole table. You could manipulate the page and make it work for visuals with measures specifing the crossfilter.
Something like this: https://blog.ladataweb.com.ar/post/666756974455799808/dax-crossfilter-y-userelationship
Regards
Thank you, ibarrau , for your response.
Hi ssspk,
We are pleased to learn that your issue has been resolved. Kindly mark the response that addressed your query as the accepted solution and give kudos. This will help other community members facing similar challenges to find solutions more efficiently.
Please continue to utilise the Fabric Community for any further assistance with your queries.
Thank you.
Hi ssspk,
We are delighted to know that your issue has been resolved. Kindly mark the response that resolved your query as the accepted solution. This will assist other community members facing similar challenges in finding solutions more efficiently.
Please continue to utilise the Fabric Community for any further assistance with your queries.
Thank you.Hi ssspk,
We are pleased to learn that your issue has been resolved. Kindly mark the response that addressed your query as the accepted solution and give kudos. This will help other community members facing similar challenges to find solutions more efficiently.
Please continue to utilise the Fabric Community for any further assistance with your queries.
Thank you.
