Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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. What power bi does is it sum the results for a date and at the end I get a weird line chart. I would like if there is two results in the same date to display the date twice on the chart.

 

Table examples:

name     result     job_id     date
aaa       pass       1             21st 2019

aaa       pass       2             21st 2019

aaa       fail         1             22nd 2019

aaa       pass       1             23rd 2019

 

I want this: 
Cout of result

|

|

|

|   val        val      val         val

_________________________________  date
   21st     21st      22nd     23rd


And not this:

Cout of result

|

|

|  val 

|              val          val

_________________________________  date
   21st     22nd     23rd

 

I hope this is clear. Tell me if you need more information.
Thank you very much for your help :) 

Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    6 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.

3 Replies

  • v-joesh-msft's avatar
    v-joesh-msft
    Solution Sage
    6 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
      6 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
        Solution Sage
        6 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.