cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

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.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors