Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have two tables with a many-to-many relationship:
The first table contains import volume data along with product and other parameters.
The second table contains prices and a product column.
To resolve the many-to-many relationship, I created a bridge table with distinct product values. In my control panel, I have a slicer that filters by product. However, when I select a product in the slicer (knowing the product parameter is already selected), all other products show as 0. This issue occurs specifically with the line graph, while all other visualizations are working fine.
I don't want to remove the "+ 0" from the measure, as it keeps the line straight when no product is selected by default.
Help Is there any solution.?
Hi @Abdelhadi- ,
It is difficult to tell the cause of the problem from the information you currently provide. How is your category parameter created? What is used in your line chart? What is the key DAX? More detailed information will help us reproduce your data. But the best thing is to provide your current pbix file and hide the private data.
Best regards,
Mengmeng Li
User | Count |
---|---|
97 | |
77 | |
77 | |
48 | |
26 |