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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
dilbagsidhu
Frequent Visitor

slicer edit interaction issue

Hello, i have card which shows candidate winner in election year 2014 for which function is

candidateWin2014 =
VAR maxvotes= MAX(Results[Total votes])
RETURN
CALCULATE(MAX(Results[Candidate]),FILTER(Results,[Total Votes]=maxvotes),Results[Year]=2014)

it works fine if i dont disable its interaction with year slicer, which has 2 year "2014", "2019".
but when i disable its interaction, for some constituencies(places where elctions were held) it shows value and for some it shows (blank).
So what could be the possible reason..
do shar eyour insight.
im attaching video link showing the issue.

1.png4.png
https://drive.google.com/file/d/1eDciGl8qlBORyPevT8aWcZztqw4ez3x9/view?usp=drive_link
5 REPLIES 5
elitesmitpatel
Super User
Super User

Sorry for very late reply , did you solve this? , if yes then please share , else we can dicuss further!! @dilbagsidhu 

dilbagsidhu
Frequent Visitor

@elitesmitpatel  in photos i wanted to highight that for some consituencies it shows value but for some its blank which should not be..

 

elitesmitpatel
Super User
Super User

1) Video is private.
2) interaction work on whole visual and table with another tables , not according to single row of the table 
3) images you shared I can't see interaction on off  sign anywhere. If possible share the file and also more details if you can?
Hope you will help me out to solve this problem @dilbagsidhu 

@elitesmitpatel i just want to stop interaction with "year" slicer as i have already applied year filter in dax function. 

with the table/matrix visual, interactive is active.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.