The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
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
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
@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
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
106 | |
96 | |
55 | |
49 | |
46 |