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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dd88
Resolver I
Resolver I

how do I link all in the report to be interactive and update

I am new to PowerBI.  I have created a PowerBI desktop report.  

 

Its a progress status report.

 

The 1st example, most of the visuals are linked and when a visual item is selected, all update correctly to display the current selection.

 

Displays

Status Totals  - Visual are Cards

Status breakdown - VIsual is a bar chart

By Issue  - Visual is a Table

By Department - Visual is a Table

Action - Visual is a Table

PowerBI - Link all - 01.jpg

 

 

The 2nd example, I added a slicer to see what it would look like. The slicer has the fields  1.Status  2. by Department  3.by the Issue and 4. Action. This is actually the information the business user wants to see. 

 

PowerBI - Link all - 02.jpg

 

In the slicer, when I select an item, how can I link it so all other visuals on the report update to reflect the selection? At the moment there are no 'links' and the reason the visuals either error or do not display.
I dont even know the terminology what that would be called, or function to ask you? for example is it a drill down?

 

Or, I am open to a better design suggestion if you have one. 

 

TIA

 

0 REPLIES 0

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.