[Power BI Report Builder] - Drop-down list after generating the report to MS Excel

[Pedro_Ziggy]

Hello Community,

I have a question about Report Builder.
How to achieve an effect in which the report, after being generated to MS Excel, contains a dropdown list as in the image below?

Thank you very much in advance.

P.S. I tried to use the idea from the following link (reporting services - SSRS report with drop down list when exported to Excel - Stack Overflow) as an expression, however it doesn't work for me.

Result:

[Pedro_Ziggy · Accepted solution]

After analyzing the topic, I conclude that the option described above cannot be implemented in Report Builder (it is not intended for this purpose).

[Anonymous]

Hi @Pedro_Ziggy ,

This problem of yours is probably not well implemented in Power BI Report Builder,

I will give you an example that will help you understand why it is not well implemented：

After we create the report in our desktop, we also have a slicer to filter the data, a

nd then when we export the data, the two are not merged.

As you can see our filters were not able to be retained in execl, so if you want to implement your functionality it is recommended that you export it and modify it in execl.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.