Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Abdelhadi-
New Member

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.?

Abdelhadi_0-1740651788410.png

 

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors