Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Generate excel report based on filters using a button

Hi everyone, 
Just want to ask if generating an Excel report is possible with power bi.

The scenario is something like this:
I'll select values in the filter on the upper part then click a learning title. After that, I'll click the generate report button then the Excel report should contain the names of required attendees, not completed and completed.


Feel free to ask for clarifications. 
Thank you, everyone.

  • You need to generate in power bi table with the same output.
    There are no other tricks 🙂

3 Replies

  • Hi Anonymous 

    It is possible to add an "Export to Excel" button to the report.
    Whatever slicers you choose, the table will be filtered.
    Further, in your picture, you have several tables. If the report is released at the same time, everything should be in a single table.

    There is also the option of designing a report as a paginated report, which has similar results..

    : Here is a tutorial video about exporting to Excel button:https://www.youtube.com/watch?v=BnTipbooeP0 

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Actually tried that, But my expected output is something like this. 

       

      • Ritaf1983's avatar
        Ritaf1983
        Super User

        You need to generate in power bi table with the same output.
        There are no other tricks 🙂