Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Missing Data in a Table

I am having an issue when I create a table … so for example, I have groups 1, 2, 3 who all have sales targets. I can pull in those sales targets for each group. Then I have a separate data set that h...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    Since I don't understand your data model, I can not reproduce your problem. Please provide sample data model like me.

        

     

    In addition, I have also tried when the sales target is also empty.

     

    Best regards,
    Lionel Chen

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

lbendlin's avatar
lbendlin
Super User
5 years ago

Use separate tables.  A "dimension" table with all sales groups.  A "facts" table with your sales data.

Link the tables in the data model.

 

In your visual, take the sales group from the dimension table (this is important!). Also select "Show items with no data".

 

Now all Sales Groups will show, regardless if they have data or not.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you for the reply!! Can you provide more details - how do I go about creating a dimensions table vs. facts table? 

    • v-lionel-msft's avatar
      v-lionel-msft
      Community Support
      5 years ago

      Hi Anonymous ,

       

      Since I don't understand your data model, I can not reproduce your problem. Please provide sample data model like me.

          

       

      In addition, I have also tried when the sales target is also empty.

       

      Best regards,
      Lionel Chen

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