Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AnurragGaurav
Frequent Visitor

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.

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

View solution in original post

5 REPLIES 5
v-kelly-msft
Community Support
Community Support

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:

Annotation 2020-04-07 122642.png

3.Finally you will see:

 

Annotation 2020-04-07 122749.png

 

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!

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

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
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.