Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

0s From Power Query Source Not Appearing in Table Visual

Hello,   I'm pulling in Production Quantity data for various Plants that are scheduled to run on a specific Schedule. The granularity of the table visual is at the Material Number level where I'm a...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I discovered the issue in my Data Model and using a column/key from my Fact table for the relationship join. The column/key isn't always populated with a value. This explains why I couldn't see the 0s.

     

    Thanks for your help!

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

Based on your description, you may try to add 0 to the target measure.

 

Here is an example.

 

You may create a measure as below.

Value - 2 = SUM('Test'[Value]) + 0

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I discovered the issue in my Data Model and using a column/key from my Fact table for the relationship join. The column/key isn't always populated with a value. This explains why I couldn't see the 0s.

 

Thanks for your help!