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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

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.