Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Experts,
Need your help! I have created a pbi report with data source as web api. Also I have created a slicer with all distinct values of departments from one table. Now the question is how do I pass the selected depratment value from slicer to this web api? web api is written in C# and would return the data for that departmnet.
Any help is highly appreciated!
Thank you!
Hi @harshadsp,
It is not possible to pass slicer selection to data source (Web API). The slicer works to filter displayed data on report view, rather than filter the loaded dataset.
Best regards,
Yuliana Gu
Thanks @v-yulgu-msft for the confirmation. I was thinking another way that I will create a icon and provide the link for the data filter but I guess that will open the another report. Is there any workaround that I can display in the same report.
Please advise. Thanks!
Hi @harshadsp,
It is not possible to pass slicer value to query string to dynamically change loaded dataset. One thing you should be aware of is that:
Power BI load data via Power Query first, then, add data from dataset into report view. Slicer displays value on report view, which is generated afterwards Power Query execution.
As a workaround, you can consider using Query Parameter which is used for Power Query, dynamically loading data based on specified value for parameter.
Power BI Desktop Query Parameters, Part 1
One limitation to this workaround is that end viewers you share report with via Power BI Service cannot change the parameter value.
Regards,
Yuliana Gu
Thanks @v-yulgu-msft for your suggestion and links. I somehow manage to create a function on top of web api url and then invoked a custom column for this function by passing the other column values as a parameter to function. Then put the other column in slicer. Now what user see is if he click on any slcier value the other graph renders for that value. Acyually the jason is already parsed from url for all the values but it visually effects what he wants.
I will go though the links and try to use the logic with other report.
Thank you so much for your time & efforts, I appreciate it!
Harshad
Hi @harshadsp,
I'm afraid such a requirement is not available now.
Regards,
Yuliana Gu
Hello all, any thoughts? Please help, thanks
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |