Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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".
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.
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".
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.
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |