Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have a question about ignoring a slicer.
I have a dim table which shows:
- customer code
- customer name
- customer group
Multiple customers can be part of 1 group or not (in that case it's blank).
I have a fact table which shows:
- customer code
- other data not important for this question
I created a report which shows all relevant data for a customer using a slicer which is based on customer name. Standard stuff.
I would like to add a table to the page which basically shows all customers that belong to the same group.
Obviously when I do that now I only see one line being the customer that I selected
When I edit interactions and remove the filter, it shows all customers.
The desired outcome should be something like this:
Any ideas?
Solved! Go to Solution.
Hi @lekkerbek
The easiest way to do this is duplicate the customer and group column into a seperate table.
Don't join this on to your existing table and then put that in your slicer.
Then you can create a measure to filter the data.
Add the measure into your Filter Pane under Filters on this visual.
filter measure =
var curr =SelectedValue(table[duplicated customer group])
Return
IF( SelectedValue(table[original customer group]) = curr, "Y")
Then filter this to Y
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Hi @lekkerbek
The easiest way to do this is duplicate the customer and group column into a seperate table.
Don't join this on to your existing table and then put that in your slicer.
Then you can create a measure to filter the data.
Add the measure into your Filter Pane under Filters on this visual.
filter measure =
var curr =SelectedValue(table[duplicated customer group])
Return
IF( SelectedValue(table[original customer group]) = curr, "Y")
Then filter this to Y
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Works like a charm. Thanks a million!
User | Count |
---|---|
111 | |
105 | |
101 | |
77 | |
44 |
User | Count |
---|---|
144 | |
142 | |
122 | |
100 | |
56 |