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

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
Exor
New Member

Dynamic Table Records

Hello! 🙂

I want the table on my Dashboard show the records depending on the selected Visuals (in this case Circle-Diagrams). The Datastructure and Dashboard is as followed:

 

Students_u_Classes.jpg

 

The Circle Diagrams may not make sence in thie example, it's just a showcase. In my own context it makes sence. 

If I select a Class in the Circle DIagram, I want the Table only to show records of the selected Class.

1 ACCEPTED SOLUTION
vojtechsima
Super User
Super User

Hi, @Exor ,
Prolly not the best model, but if you put "Both" crossfilter option in each relationship, it should work as you want.

 





Any kudos or recognition appreciated. To learn more on the topic, check out my blog and follow me on LinkedIn.

View solution in original post

3 REPLIES 3
vojtechsima
Super User
Super User

Hi, @Exor ,
Prolly not the best model, but if you put "Both" crossfilter option in each relationship, it should work as you want.

 





Any kudos or recognition appreciated. To learn more on the topic, check out my blog and follow me on LinkedIn.

Thank you for the quick answer and solution, it worked! @vojtechsima  😍

 

An other slightly related question: Can I adjust the Circle Diagrams in a way, that they only show the selected Records? 
Example: I select a student in the "student-circle-diagram" . I want the "class-circle-diagram" to only show the classes, in which the selected student participates. Right now the classes are only highlighted, but i can still see the others.

Hi, @Exor 
You click on visual that you want to edit (this mean, you change how this visual will interact with other visuals):

vojtechsima_0-1668268984352.png

You go here

vojtechsima_1-1668268991895.png

 

And in the visual that you want to change from highlight to filter, you click the filter icon:

vojtechsima_2-1668269040485.png

 

 





Any kudos or recognition appreciated. To learn more on the topic, check out my blog and follow me on LinkedIn.

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

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

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.