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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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