The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
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:
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
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
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:
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):
However, once I add the User count all the sectors appear in the visual, even 'Utilities':
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.
User | Count |
---|---|
87 | |
84 | |
36 | |
35 | |
30 |
User | Count |
---|---|
96 | |
74 | |
67 | |
52 | |
51 |