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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Daisy Chain Visuals

New to Power BI.

 

Working with Power Apps and SharePoint.

 

I've created a Report that has several visuals - one Table and two Clustered bar charts.

 

I would like basically a step-down functionality pointing to specific data based on the choice in the previous chart.

 

What I get now is the number part.

 

In 'nuetral' I can see grand totals, across multiple areas in visual 1.

 

If I click on one of the grand total graph lines in visual 1 it triggers a sub-set of data in visual 2.

 

I go from Total items in the store to specifically Total items of fruit (kind of thing).

 

What I need is when I click on a sub-set fruit graph line in visual 2 I need the data in the sheet to be specific the the type of fruit represented by the bar graph choice in visual 2 & only in the 'Area' represented by the choice made in visual 1. 

 

1. Visual 1 shows a chart with all 50 starts and a line representing the number of cites in each state.

2. If you click on a State in visual 1 the chart in visual 2 displays a list of cities based on location (east, west, north, south), with the number on the graph line representing the number of cities in each 'Area'.

3. If you click on visual 2 graph line the Table display specific Building information, based on the Area chosen in visual 2 & the State chosed in visual 1 - ONLY.

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors