Forum Discussion
Filtering a Line Graph with a Category Share Measure Without Removing the '+ 0' from the Measure
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.?
1 Reply
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
