Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Parallel charts

Hi,

I have two charts the first chart contains values for all the associates, but the second chart has values for only few associates.

How can I show the corresponding associate from the first chart in the second even if it dosent has any value.

 

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Thanks a lot Lydia and Phil, I have fixed the issue now.

     

    regards,

    Ravi

4 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Hi Anonymous

     

    Just make sure the Measure you are using in your chart returns a 0 value for the item.  If it returns a BLANK() it won't go on the axis.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Anonymous,

    Do you create the two charts using fields from different tables? If so, do you create relationship between the two tables using id field? When relationship exists, you can create the second chart by putting id field of first table in Axis, and make sure you select “Show items with no data” for Axis.


    However, if above step doesn’t help, please help to post table structure in your scenario .

    Thanks,
    Lydia Zhang

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thanks a lot Lydia and Phil, I have fixed the issue now.

       

      regards,

      Ravi

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Anonymous,

        Glad to hear the issue is solved. You can accept helpful replies as answer, that way, other community members would easily find the answer when they get same issues.

        Thanks,
        Lydia Zhang