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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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
Solution Supplier
Solution Supplier

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
Solution Supplier
Solution Supplier

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Top Kudoed Authors