cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nogi
Advocate II
Advocate II

Card visual - Can't filter table on click

Ok, not sure if i can explain this correctly but here we go. When you have a graph and click on an element the table on the same report will filter down to show what you have selected in the graph. e.g select October bar in graph shows details on all october widgets in the table.

 

How do i get this same behaviour using the cards visual? I have a card that shows the number of milestones completed. A table on the same page with all the tasks. I want the table to show only milestones completed if someone clicks on the card visual.

1 ACCEPTED SOLUTION
v-caliao-msft
Microsoft
Microsoft

@nogi,

 

Currently, card visual is not able to click. So I am afraid your requirement cannot be done. If you are good at coding, you could create your own costom visual based on your requirement. 
https://powerbi.microsoft.com/en-us/documentation/powerbi-custom-visuals-getting-started-with-develo...

 

Besides, If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Thank you for your understanding.

 

Regards,

Charlie Liao

View solution in original post

2 REPLIES 2
xonde
Frequent Visitor

Hey,

 

I found this really cool trick (more of a hack) to work around this, You can use any visual you want (that has the "clicking" feature), I normally use a Pie chart. Format the visual so it only shows the value that the card shows (you can do this by excluding columns and groups in the visual level filter), then make the data colour of the visual white (or whatever your background colour is) and make the data label what ever color you want it to be, Increase the font size of the data label and give the visual a title and voila! You now have a visual that looks like a card but with the extra functionality of being clickable to filter other visuals and tables. Hope this helps. 

v-caliao-msft
Microsoft
Microsoft

@nogi,

 

Currently, card visual is not able to click. So I am afraid your requirement cannot be done. If you are good at coding, you could create your own costom visual based on your requirement. 
https://powerbi.microsoft.com/en-us/documentation/powerbi-custom-visuals-getting-started-with-develo...

 

Besides, If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Thank you for your understanding.

 

Regards,

Charlie Liao

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors