Hello community,
I'm trying to get my 2 product slicers, based on unrelated product tables DIM_PRODUCT and DIM_PRODUCT_2, to filter one product table and show both products and their Volume measure. Basically, I want Product B, coming from DIM_PRODUCT_2 and selected in the 2nd slicer, to show as a 2nd row in my table with its Volume measure. Current Volume measure looks like this: Volume = sum(FACT_VOLUMES[VOLUME]). Currently only Product A, coming from DIM_PRODUCT table, is showing, although slicers with both Product A & B are selected:
Can you please help me with making both selected products show up in the table without creating any new relationships in the data model? I'm also attaching a screenshot of the model view and a link to the dashboard (sample version).
Thank you!!
@kristinamol check if this video on my channel helps Compare selected customer sales with other customers - various methods (Part 1) - YouTube
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Power BI Monthly Update - June 2024
Check out the June 2024 Power BI update to learn about new features.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
