cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PrivateAnalytic
Helper III
Helper III

Assistance with a Slicer and Tips

Hello everyone!

I am working on a report which helps simply display information over Spammed messages over time. The data is depicted below, and is showed as eiher "Yes", "No", or BLANK:

PrivateAnalytic_0-1660657982991.png

I have a tab in my report which shows the folks who have replied to multiple spam messages, which is represented in a table:

With Name being a normal column from the data, and # of Messages being displayed as a Count of the Spams sent.

The Failures column is a created column with the following: IF('Messages'[SpamFail] = "Yes", 1, 0) and is represented as a Sum in the visual.

PrivateAnalytic_1-1660658166481.png

ISSUE:

I have 3 slicers created on this page of the report, to drill down to the name of the person, the amount of Failures folks have, and the date the spam messages occurred. If I use just one of the slicers, they work great! However, if I am drilling down to a specifics. If I want to select multiple folks from the person filter, the specific dates of the spam messages, my Failure Slicer doesn't respond to it. 

Example: 

When you open the report, you can slide between folks with 1 failure up to 18 fails.

PrivateAnalytic_2-1660658754308.png

However, when I change the date slicer to lower population, it does not reflect the amount of fails.

PrivateAnalytic_3-1660658829377.png

The date will reflect the table below, and the count slicer still puts an effect to the table, but it is not accurate at all.

PrivateAnalytic_4-1660658930543.png

One thing I would I would assume would be an issue with this is the fact that the slicer is using a different field than the # of Failures one. The slicer is using a formula like:

CALCULATE(COUNTROWS('Messages'),

FILTER('Messages', Messages[ID] = EARLIER(Messages[ID]) && 'Messages'[SpamFail' = "Yes"))

 

However, if I try to switch the Fails slicer with the same column to be consistent, it won't work of course because I can only slice between 0 and 1. 

 

Was wondering if anyone had any sort of tips, tricks, or ways to maybe get everything working together?

1 REPLY 1
lbendlin
Super User
Super User

 

the amount of Failures folks have

 

That is too fluffy.  You will need to find a better definition. Once you have that you can write measures that are impacted by some slicers but not by others.

 

Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. Screenshots of your source data are not useful.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors