Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Bar graph with duplicate value on y-axis

I have a requirement to create a Bar graph with duplicate values on y-axis. For example: For a current day, "Job 2" runs twice and it takes 20 mins for first run and 40 mins for next run.

 

How can I achieve this? I want that above would not effect any slicer or filter conditions.

 
 
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    My suggestion is a workaround for you,as in bar chart,for the same category,the related value will be aggregated while showing in the graph,so the best way is to make a difference for "their names".

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Would need to see sample data. What is on your x-axis? Job number? If you had a "run" column, you could create an ad-hoc hierarchy for the x-axis and drill into it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      We have the following data.

      Y-Axis "Job name"                                X-Axis "RunTime in Minutes"
      Job1                                                      10
      Job2                                                      20
      Job3                                                      30
      Job2                                                      50

      x-axis will have run time, and the job name will be on the y-axis. However, job name should get duplicated. Fox example: Job2 would occur twice on y-axis.

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    1.Go to query editor and add an index column;

    2.Using below dax expression to create a calculated column :

     

    Column = 'Table'[Column1] & "-"&'Table'[Index]

     

    And you will see:

    3.Finally you will see:

     

     

    I made a sample .pbix file you can refer to.pls click here.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-kelly-msft ,

       

      Thanks for the response. However, as per your graph. We wanted to display "Job 2-1" and "Job 2-2" as Job 2 only. This is possible in excel. So, how can we achieve that in Power BI?

       

      Regards,

      Anurrag Gaurav

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ，

         

        My suggestion is a workaround for you,as in bar chart,for the same category,the related value will be aggregated while showing in the graph,so the best way is to make a difference for "their names".

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!