Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am trying to create a view in which we have two tables- One is the aggregated one and other is the raw data. I want two visuals in it, one is the stacked bar graph from the aggregated table and another is a table of raw data.
I want whenever the user click on any stack of the stack bar chart it should be able to filter out the data in the table based on that selection.
Any idea how to do that?
Solved! Go to Solution.
You need to connect the two table together in Model view (third icon down on left, shows you the two tables next to each other. Then drag one field where the values are found in both tables from one to the other - they should now appear connected).
When you create the visualisation in Report view this should then work automatically.
If it doesn't click on the bar chart, select "Format/Edit interactions" and then on your raw table click on the icon that's a chart with a small filter in front of it.
Matt
You need to connect the two table together in Model view (third icon down on left, shows you the two tables next to each other. Then drag one field where the values are found in both tables from one to the other - they should now appear connected).
When you create the visualisation in Report view this should then work automatically.
If it doesn't click on the bar chart, select "Format/Edit interactions" and then on your raw table click on the icon that's a chart with a small filter in front of it.
Matt
Can you connect the tables in the model?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
78 | |
69 | |
69 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |