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
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
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
Solved! Go to Solution.
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'
This will show icons next to other visuals on the page, which will let you control whether the slicer
filters
or doesn't filter
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'
This will show icons next to other visuals on the page, which will let you control whether the slicer
filters
or doesn't filter
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
83 | |
76 | |
64 |
User | Count |
---|---|
142 | |
112 | |
98 | |
98 | |
94 |