Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello all, I am new to PowerBI and need your help. I have simplified it below:
I have a table 'Transactions' with the following details: 'Order Number', 'Product Number', 'Sales', which might look like this:
1 A 10€
1 B 15€
1 C 7,5€
2 A 10€
2 C 7,5€
3 B 15€
3 C 7,5€
...
I now want a page, where I can select a Product in a slicer and get a table visual, which shows all Products, that were bought in the orders, which contain the product filtered to and the corresponding sales of the individual products, which might look like this:
Slicer: Product A
Table Visual:
A 20€
B 15€
C 15€
...
So basically, I want the product slicer to filter for a list of orders, which contain the product, but the table visual to only reference to this list of orders and show the included products. This should be working dynamically, so it adjusts everytime I choose a different product in the slicer.
How do I achieve this? Many thanks for your help.
Solved! Go to Solution.
Hi @derromma,
Take a look at the new pbix file and see if it's what you're looking for.
Proud to be a Super User!
Hi @derromma,
Take a look at the new pbix file and see if it's what you're looking for.
Proud to be a Super User!
Dear @_AAndrade , another question came up on my side on this topic:
I have a table visual which displays Sales on total OrderNumber Level (on orders that contain product X) which is also linked to a ProductNumber Slicer. It would be very helpful, if I could click on an order number from that table and have the bottom table (the one on Product Level) show only the products and corresponding valus that were in that specific order.
The current Measure "NewSum Basket" is not affected by filtering for a single Order in the table. This kind of Filtering worked however in the first solution you provided. Is there any way to make this work with the current measure "NewSum Basket"?
Thank you!!
Hi @derromma,
I'm attaching my solution in pbxi file.
The final output is this:
Proud to be a Super User!
Many thanks for your swift help, really appreciated! It works a treat. I do have a follow up question though: If I now wanted to get the product name into the table visual, from a second table "masterdata" (which is linked to my 'Transactions' table via the "product number", how would this work?
If currently I add the 'product_name' to my table visual, it starts filtering to only the selected product of the slicer.
User | Count |
---|---|
77 | |
77 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |