Forum Discussion
Table Display
Hello, We are creating a dashboard in Power BI and are having difficulty with a display request from our users. I am hoping you can help with that because I don't know how to start this. Our...
Sorry this is not a finished solution, but I am a volunteer who provides free BI support in my spare time and it is now past my bed time.
Click here to download a solution
I have used Power Query to create 3 tables:-
- Items (with item code)
- HQ (with inventory and demand just for WHSE 0002)
- Local (with inventory and demand just for WHSE 0002)
Then joined the tables with relationships
Then created DAX measure for
- HQ invetory
- HQ demand
- Local invetory
- Local demand
This makes building reports much easier
The left visual show just items that have HQ invetory AND Local demand.
If you click on an item on left visual then the right hand visual will show the local warehouses that have the demand.
It needs tweaking for your exact requirements but I hope that this first stab helps!
I will try have a look again tomorrow in my lunch break. 😁