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
Br4v3D4v3
Frequent Visitor

Data Visualisation with table and a single-select slicer

Hello everyone,

I'm hoping you could help me with a problem I have in my report. I'm new to Power BI in general so maybe I'm missing something.

 

I have a report / dashboard consisting of 3 distinct views - dashboard style Welcome screen, report Overview with all items available in the data driving tree maps and a table visual, and then a Details screen with text wrappers driven by slicers.

 

All of these work great separately but I've been asked to look into a solution where selection made on the table automatically updates the slicer selection in the Details screen. I tried replacing the table with another slicer but that didn't work as multiple selections don't work in the Details screen and single selections make the tree maps useless.

 

I've attached a few screenshots.

 

Details Page.png

 

MainPage.png

 

Please help...

 

Thanks for reading...

2 REPLIES 2
lbendlin
Super User
Super User

Use the filter pane as it is intended to be used ("filter on all pages")  or use synchronized slicers on the affected pages.

Thanks for the reply.

 

I have synchronised slicers to select project names for the "details" pages (there are two of them) and the filters aren't "interactive" enough as I also need to get the table to show the list of items filtered by a date slicer, which is in turn synced with the other two pages.

 

The original idea was to have a list of projects in a table, slicer with dates when submissions were made, tree maps to visualise status updates. Selection on a tree map then filters the table, table selection filters the tree maps.

The second part of the report is the update details where two slicers let users view updates based on project name (same as the table in the first screen) and date (synced slicer that matches selection in the first screen).

 

The users are asking for a way to select a record in the table and then view the details without having to change the slicer on the detail pages.

 

Br4v3D4v3_0-1664185420600.png

The map above should make a bit more sense of all of this. It doesn't have to drive the slicer (I can hide it and add a button to show it if someone wants to change the project manually). Any ideas are welcome.

 

Thanks

David

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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