Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to display mutliple value for the same date

Hi everyone, I have a line chart that display a count of result by date. My problem is that sometime I have two results for the same date. They are different by a job id but same for the date. Wh...
Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    7 years ago

    Hi, Anonymous 

    After my research, you can try to achieve an approximate effect by adding a secondary column, the steps are as follows:

    1. Create an index column and change the index column type to text;1
    2. Create a new Custom column, use the formula: = "-" & [Index], and then delete the index column;23
    3. Create a line chart and add the Custom field you just created to Axis, and you will see a hierarchy on the line chart;4
    4. Select Expand all, the corresponding screen may be what you want, the result is as follows：5

     

    Here is demo , please try it：

    https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EfS8EqQ7fDJGvC2PT2G5kJUBa7uAECXHMQ9al6VMlr6ynA?e=FE8Gax

     

    Best Regards,

    Joey

     

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

v-joesh-msft's avatar
v-joesh-msft
Icon for Solution Sage rankSolution Sage
7 years ago

Hi, Anonymous 

After my research, you can try to achieve an approximate effect by adding a secondary column, the steps are as follows:

  1. Create an index column and change the index column type to text;1
  2. Create a new Custom column, use the formula: = "-" & [Index], and then delete the index column;23
  3. Create a line chart and add the Custom field you just created to Axis, and you will see a hierarchy on the line chart;4
  4. Select Expand all, the corresponding screen may be what you want, the result is as follows：5

 

Here is demo , please try it：

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EfS8EqQ7fDJGvC2PT2G5kJUBa7uAECXHMQ9al6VMlr6ynA?e=FE8Gax

 

Best Regards,

Joey

 

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
    7 years ago

    Hi !

    Thanks for your reply and the time spent to try something :) 

    I just tried it and it looks perfect. I will accept your answer as the solution ! 
    Quick questions about your answer:
        1 - Why this "= "-" & [Index]" and not only the index ? 

        2 - How can I remove the display of the index on the "x" axis ?

     

    Thanks

    • v-joesh-msft's avatar
      v-joesh-msft
      Icon for Solution Sage rankSolution Sage
      7 years ago

      Hi  Anonymous ,

      For your question, I hope the following answers can be resolved:
      1. This formula: = "-" & [Index]", just to visually distinguish better, you can also use only the index, but it may be visually confusing, you can also customize a formula that you feel better;
      2. The chart will aggregate options with the same value, so the value of the x-axis must be unique to achieve the desired result. If the display of the index is removed, the ideal result will not be achieved.

       

      Best Regards,

      Joey

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