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
Anonymous
Not applicable

complex slicer question

Hi,

 

I am trying to figure out how to make parts of my visual ignore a slicer.


I have two tables: one containing a list of users and their demographic information and another containing data on those users activities relating to stocks.


I have a 'user id' slicer that affects every visual on the page - so you select a user id and see specific information on that user's activity, e.g. what stocks he liked in what sectors.


However, I now want to look at the connections between the chosen user's and other users' activity.

I have a network visual that displays all the sectors the chosen user liked stocks in and also the number of other users who liked stocks in the same sector.

network.PNG
For the second level of the network visual I want to pull in the demographic data on those other users and look at the number of userd in the different age buckets, income buckets etc. The issue is that because of the slicer I can only ever see the specific age / income etc. bucket that relates to the chosen user. Like this:

network2.PNG

 

If I make my visual ignore the slicer then there is the problem of seeing the other sectors as well and not just the ones the chosen user has liked.

The goal would be to see that e.g 46 users liked a stock in the Consumer Discretionary sector and 5 of those were <25, 15 of those were 25-45 etc.
Is there any way to do this - i.e. make the demographic data ignore the slicer while my sector data still considers it?

 

Many thanks,

Ginny

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

Seems to me that you want some sort of measure calculation that adjusts how the slicer is used to filter by overriding it in certain circumstances. If and how exactly that would work can't really be determined from the information presented. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@Greg_Deckler 

Sorry, I realise that wasn't clear, let me explain it by taking a different approach.

 

So I have my Activity data ('UV for Rapidminer (Machine Gen)') containing user IDs and sectors. I have a row for every single time a user has viewed a sector.


I also have my Demographic data ('Distinct IDs') containing the user IDs and personal information (age, income etc).

 

The two tables are connected via the user IDs.

 

I have a user ID slicer and I want to show how many people other than the selected user viewed the same sectors as the selected user.

So I wrote a measure that counts all the distinct user IDs in the activity data EXCEPT the one selected in the slicer:

measure.PNG

If I put this into, let's say, a matrix, the issue is that I now get all the sectors listed, even the ones that weren't viewed by the selected user.
Let me explain what I mean.


In this example the selected user, user 3, has never viewed 'Utilities' as you can see below (it's missing from the list):table1.PNG

 

However, once I add the User count all the sectors appear in the visual, even 'Utilities':table.PNG

 

My goal is essentially to get a table that shows the exact same values as the one above but without 'Utilities' as that is not something that was viewed by the user selected in the slicer.

 

I hope this makes sense.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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