Forum Discussion

Pedro_Ziggy's avatar
Pedro_Ziggy
Regular Visitor
2 years ago
Solved

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

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:

Need Help
  • Pedro_Ziggy's avatar
    Pedro_Ziggy
    2 years ago

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

     

     

  • Pedro_Ziggy's avatar
    Pedro_Ziggy
    Regular Visitor
    2 years ago

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