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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Employee
Employee

@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
Employee
Employee

@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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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