Forum Discussion
Multiple X Axis Charts
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!
2 Replies
Hi Anonymous ,
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
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.