Bar graph with duplicate value on y-axis

[AnurragGaurav]

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.

[v-kelly-msft]

Hi @AnurragGaurav ,

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!

[AnurragGaurav]

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 · Accepted solution]

Hi @AnurragGaurav ，

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!

[Greg_Deckler]

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.

[AnurragGaurav]

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.