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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors