Is dual axis gantt chart possible in power BI?

[Samruddhi_11]

Hii,

This is dual axis gantt chart in tableau. Can we implement same in power BI?

Please refer below datasets,

In tableau, on rows fields are record type A and record type B and on column fields are value 1 and value 2. that makes the dual axis gantt chart. is same possible in power BI? please suggest your ideas. Thanks!

12

[VahidDM]

Hi @Samruddhi_11 

Please check these two visuals in Power BI:

Gantt Chart - xViz 

Gantt Chart 

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

[Samruddhi_11]

Yeah thanks! @VahidDM . I have tried gantt chart but it is taking only one axis on row. But I wanted to have dual axis. Thanks.

[v-rzhou-msft · Accepted solution]

Hi @Samruddhi_11 

You can't use dual axis from two tables in power bi. I think you can rename original Type column as Category, add a Type column with "Type A/B" in two tables and append two tables as one. Try legend function in Power BI. 

My Sample:

A

Add a type column by custom column.

Do the sample step in Table B and Append two tables.

For reference: Append queries

New table looks like as below.

Result is as below.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Samruddhi_11]

Thanks!! @v-rzhou-msft