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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 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.

Top Solution Authors