- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Fliter/slicer on multiple columns if they appear in either column of a function
Hi I'm new to the board and PowerBI, I've spent all day trying to find a solution to this on the board but haven't managed it yet. I thought I'd got there but the Dax said no.
I am looking to visualise some supply chain data using 'Flow Map' but I can't work out how to create a filter/slicer that allows me to show a location as both a receiving and supplying site
I want to create a Filter that shows both Supplier site Or Delivery site, so my Filter if I selected Site C would keep both in bold below so the flow into site C from Site B and the one Out to Site D, is this possible? Thanks
Data
Supplier Site | Delivery Site | Product |
Site A | Site B | X |
Site B | Site C | Y |
Site A | Site D | Z |
Site C | Site D | X |
Site B | Site A | Y |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Create an independent Site dimension, do not join or create the inactive join
measure =
var _max = maxx(Site ,Site [Site ])
calculate(count(Table[Product]), filter(Table, Table[Supplier Site] =_max || Table[Delivery Site]=_max))+0
On this measure create font formatting when >0 then bold
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks, but I don't think I explained myuself very well.
I am looking for a filter/ slicer just for sites, that I can then apply to a larger dataset so don't think Product should be in the formula.
I've got a map that currently shows all movements from Supplier to Customer, but some sites are both customers and suppliers
so want people to be able to select a single site which shows flows into a Site and out of it. I've tried to show in a picture. in the example below on a filter for C it would show B to D and C to D, but not the ones out of D.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@amitchandak sorry didn't tag did you have any other thoughts to my problem, after hopefully I explained it better?
Even if it's around a better way to structure the data to achieve the required outcome.
Thanks
David

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-21-2024 12:59 AM | |||
05-15-2024 01:07 PM | |||
11-13-2022 11:52 PM | |||
08-04-2024 08:10 PM | |||
07-24-2024 02:02 PM |
User | Count |
---|---|
123 | |
103 | |
84 | |
49 | |
46 |