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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
IanCockcroft
Post Patron
Post Patron

Visual to use only one slicer

Hi guys, doing my nut with this issue. I'm sure there is a simple fix.

Job SLA is reported on.

SLA status can be "Met" or "Missed" per job, per date.

I have 2 visuals and 2 slicers.

the 2 slicers are on date and a 

job category(level).

 

the one visual is a pie with SLA status for a particuar day. day is selected in the date slicer and the job category slicer.

 

the other visual 100% stacked column. X-Axis is by day, y-axis by SLA count and the legend SLA status.

this visual needs to show a trend overtime.

 

the issue is, if i select a date, the trend visual only  shows 1 day. i need it to show all the dates and still need it to be sliced by job category

 

1.png2.png

 

How do I only use the job category slicer on the trend visual?

I have tried with DAX, but cant get it right.

i have attached a PBIX with all my attempts.

thanks a mil guys

ian

1 ACCEPTED SOLUTION
AntonioM
Solution Sage
Solution Sage

You can remove the interaction between the slicer and that specific visual.

 

With the slicer selected, go to the FORMAT tab and click on 'edit interactions'

AntonioM_0-1659608206689.png

 

This will show icons next to other visuals on the page, which will let you control whether the slicer

filters

AntonioM_1-1659608234946.png

or doesn't filter

AntonioM_2-1659608267245.png

 

 

 

 

View solution in original post

1 REPLY 1
AntonioM
Solution Sage
Solution Sage

You can remove the interaction between the slicer and that specific visual.

 

With the slicer selected, go to the FORMAT tab and click on 'edit interactions'

AntonioM_0-1659608206689.png

 

This will show icons next to other visuals on the page, which will let you control whether the slicer

filters

AntonioM_1-1659608234946.png

or doesn't filter

AntonioM_2-1659608267245.png

 

 

 

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.