Alternate of dual axis of tableau in power bi

[KharansuR]

Hi,

I have a visual to migrate from tableau to power bi. In tableau we are shwoing Site and plants on the Y-axis, and Dates on X-axis and Sum(D2D Lead time) with dual axis on Y-axis. How can I show it in Power BI?

Please refer the screenshot attached.

Thanks

[shafiz_p]

Hi @KharansuR  You can acheive this using small multiples. See the image below :

Number of orders by month, divided by year and segmented by product line.

Hope this helps!!

If this solved your problem, please accept it as a solution!!

Best Regards,

Shahariar Hafiz

[KharansuR]

Thanks  shafiz_p for the quick response. But as you can see, the requirement is for a continuous trend line. Is that exact visual possible in Power Bi?

[Anonymous · Accepted solution]

Thanks for shafiz_p and Uzi2019's concern about this issue.

Hi, @KharansuR 

I am glad to help you.

In Power BI, it is not possible to show different Plans up and down as in your screenshot, but it is possible to show them left and right, something like this:

You can set the corresponding value to be displayed:

And you can also set the style of the change point:

I've attached the pbix file for this small example below, hope it helps you.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Uzi2019]

Hi @KharansuR 

Try to use legends and small multiple on site and plant.

I hope that helps.