Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Extracting Underlying Data from Card Visual

Dear All, I created a lot of cards in one of my dashboards, the requirement is the management want to export the underlying data of each card. for example one card of "Total Active Employee" , they...
Need Help
Show and Tell
Tips and Tricks
Fowmy's avatar
Fowmy
Super User
2 years ago

Anonymous 

Following the best practices, you should encourage the data to stay in Power BI and provide requred analytics. One suggestion is to use drill-through from your card visual to reuired breakdown: Card drill through in Power BI – XXL BI

However, if you need to provide access to your users download the underlying data (details), you can enable it on the Report settings in Power BI Serivice.


When they click on the three dots, to export data,  Underlyding Data option could be selected.

 







  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Dear Fowmy , Thanks for your reply.

    However, this is not solving the issue, I already provided the users access to download the underlying data. when they export the card underlying data. it only shows the card value .. 

    for example I attached here a very dummy and basic pbix. it has employees ,,, active employees in may 2022 is 50 ... I want the user to be able to export the data of this 50 employees with their attributes (their sections, grades, ... etc)

     

    • Fowmy's avatar
      Fowmy
      Super User
      2 years ago

      Anonymous 

      In that case, as I mentioned above, you should provide drill through option from your card, then once they go to this break down they can click on the three dots and export the data:
      Watch this video, it should hhelp you: https://youtu.be/vFPUslxcFj4