Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AG701
Regular Visitor

Drilldown from card to table view

Hi All,

 

We have a dashboard where cards are being used to show the summarized (count) value. Now we are trying to get the details of those records. Can anyone offer any suggestions on how I can see those records in table for the summerized data?

 

AG701_0-1660914671702.png

 

These are the 3 cards and upon click on this numbers want to view the details of 183/2/1 records respectively. 

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

Hi @AG701 

Thanks for reaching out to us.

please try this, add a page named as "detail", and create details table visual on it, then go to Visualizations and set cross-report on, then select Drill through 

 

vxiaotang_2-1661311189015.png

vxiaotang_1-1661311156526.png

FYI:  Card visual Drill through in Power BI - Power BI Docs

 

Best Regards,

Community Support Team _Tang

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

View solution in original post

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi @AG701 

Thanks for reaching out to us.

please try this, add a page named as "detail", and create details table visual on it, then go to Visualizations and set cross-report on, then select Drill through 

 

vxiaotang_2-1661311189015.png

vxiaotang_1-1661311156526.png

FYI:  Card visual Drill through in Power BI - Power BI Docs

 

Best Regards,

Community Support Team _Tang

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

rsbin
Super User
Super User

@AG701 ,

There are a few different ways this can be done.  My preferred method is to simply create a Bookmark Button

rsbin_0-1660916896181.png

rsbin_1-1660916936295.png

The Bookmark page contains the details in a table visual.  Just can't show the final table here.

Hope this method works for you.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.