Multiple X Axis Charts

[Anna2000]

Hello, I am trying to replicate an excel chart i made:

The particularity here, is not only the two Y axis (easy to do with a combo chart) but alos there are 2 X axis. The line follows a weekly progression and the columns follows a monthly one. In excel i made it from a table that had a similar shape:

As you can see, the data from the columns (the one with the red line) is in a merged cell (the size of the merged cell is equivalent to the size of the number of weeks in that month), and the line data is equivalent to one small cell (thats for the weekly evolution).

I am sure that this is also possible in power BI, but i am currently struggling with it. 

Any tips on how to create charts with multiple X axis are appreciated. 

Thanks!

[Anna2000]

 Thank you for your reply. 
I downloaded the extension and tried to do as you sai, but unfortunately i cannot see how to create the second X axis

this is my visualisation page and the resuolt is this one

What am i doing wrong?

Thanks!

[Anonymous]

Hi @Anna2000 ,

One possible solution is to use the Power BI custom visual called Multiple Axis Chart by xViz. This visual allows you to create charts with up to five X-axes and five Y-axes, and supports various chart types such as column, line, area, and scatter.

To use this visual, you need to download it from the AppSource marketplace and import it into your Power BI report. Then you can drag and drop the fields you want to use for the X-axes, Y-axes, Legend, and Tooltips.

Customize X-axis and Y-axis properties - Power BI | Microsoft Learn

powerbi - Power BI - Creating a Clustered Column Chart with Multiple (X-Axis) Values - Stack Overflo...

Solved: Two values in x axis - Microsoft Fabric Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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