cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dkk427 Frequent Visitor
Frequent Visitor

Power Bi Slicer won't update visual values

I am fairly new to powerBi and a first time poster, so sorry for any incompleteness in my posting. I am analyzing survey results. I have one column that returns a list of all the departments they have worked with to at our company. I then added a slicer to find if that broke out the deparments and searched in the department column to update the results:

 

Here is that measure:

IsFiltered =
IF(
SUMX('Slicer',
FIND(
'Slicer'[Departments],
MAX('Why Havent you enrolled'[Departments]),,0)) > 0,
"True",
"False"
)

 

Then I filter on the Chart to show Is Filtered = 'True'

 

But when the chart updates it does not bring in the correct count for anything, it updates the column values perfectly, but it is still retaining the count prior to the slicer. 

 

The photos below are the original without clicking on a deparment. For this example I click on coolsculpting as the department, (they should only have one reason, "I am healthy and do not need a portal" as reference in image 3). It is returning the reason correctly, but it is still has the number as 4 when it should be 1. What Am I missing.

Snip 1.PNG

 

Snip 2.PNG

 

Snip 3.PNG

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
dkk427 Frequent Visitor
Frequent Visitor

Re: Power Bi Slicer won't update visual values

Yuliana. Thanks for Responding. I end up figuring it out. What I ended up having to do was doing a sum with a filter and put that value in my display rather than a straight count:

 

Enrolled Department Count = CALCULATE(sum('Why Havent you enrolled'[Count]),(FILTER('Why Havent you enrolled','Why Havent you enrolled'[IsFiltered] = "True"))).

 

And then I removed the aformentioned IsFiltered from my filters.

 

After I made those two changes it all worked for me.

 

 

 

View solution in original post

2 REPLIES 2
Microsoft v-yulgu-msft
Microsoft

Re: Power Bi Slicer won't update visual values

Hi @dkk427,

 

Could you please share some sample data and provide more details about how to reproduce your scenario? In above post, you said "It is returning the reason correctly, but it is still has the number as 4 when it should be 1", how did you calculate the count value? 

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dkk427 Frequent Visitor
Frequent Visitor

Re: Power Bi Slicer won't update visual values

Yuliana. Thanks for Responding. I end up figuring it out. What I ended up having to do was doing a sum with a filter and put that value in my display rather than a straight count:

 

Enrolled Department Count = CALCULATE(sum('Why Havent you enrolled'[Count]),(FILTER('Why Havent you enrolled','Why Havent you enrolled'[IsFiltered] = "True"))).

 

And then I removed the aformentioned IsFiltered from my filters.

 

After I made those two changes it all worked for me.

 

 

 

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors