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...
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!
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!