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 learn...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

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

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

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
    3 years ago

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

     

    • Ritaf1983's avatar
      Ritaf1983
      Icon for Super User rankSuper User
      3 years ago

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