Forum Discussion
Helper ILine and Stacked Column Chart Yaxis Customization
Hello, I am writing this post because I can find a way to customize the quantities on y axis.
I have a Line and Stacked Column Chart on which I have both lines and columns with the same Measure Unit. Now, I want to add a new line but I need to set it on the secondary y-axis. This seems not possible because if I activate the secondary axis, all lines are pushed on it.
Is there a way to solve this problem?
Thanks in advance.
Hi marco_2020 ,
Try to use a custom visual - Multiple Axes Chart - XViz.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
10 Replies
- MFelix
Super User
Hi marco_2020 ,
On this type of chart the columns are place on one y-axis and the lines no another one if you turn on secondary axis so there is no "workaround" this.
But can you please explain a little bit better what you are trying to achieve? Maybe using a custom visual or some measure there is the option to do what you need.
marco_2020Hi MFelix,
thank you for you answer. I need exacltly the "Line and Stacked Column Chart" with the possibility to add another line to place on the second axis. So I have 2 stacked columns and 1 line on the first y-axis and another line on the secondary axis.
Do you know any workaround for this?
Still thanks.
- MFelix
Hi marco_2020 ,
Sorry I wasn't clearn on my question.
How do you have the chart setup, do you have legend, do you have measures, are you having one measure in % and the other in quantity?
can you share some more insight.
- amitchandak
marco_2020 , I did not get it completely. But you have the option to Show secondary
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
- marco_2020
Hi amitchandak and MFelix,
I have in total 4 quantities to be plotted. 3 of them havent unit measure (they are 3 different count), while the 4th has its own unite measure.
2 of the first 3 quantities have to be plotted in stacked columns, while the other with a line. For these 3 quantities I don't need the secondary axis.
I want to add the 4th quantity as a further line and I want it on the second y-axis.
All 4 quantities are Power BI measures.
Have I been clearer?
Thanks
- MFelix
Hi marco_2020 ,
You are clear but I still have one question are the two lines with different units values meaning is one in tousand and the other units?
I just want to understand your data so I can tell you the best option.
But please check the custom visual below that allows to customize x-axis by series type
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000183?tab=Overview
- Icey
Community Support
Hi marco_2020 ,
Try to use a custom visual - Multiple Axes Chart - XViz.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- marco_2020
Hi,
I have tried the Custom Visual you proposed. I have a couple of questions:
Is it possible to change colors as for the PBI original charts?
Do I have to buy license for publishing or is there a sort of free license with only some functionalities?
Thanks,
Marco
- Icey
Hi marco_2020 ,
Sorry to reply late.
Is it possible to change colors as for the PBI original charts?
Yes. Please check:
Do I have to buy license for publishing or is there a sort of free license with only some functionalities?
Yes. For details, please refer to this web page: https://xviz.com/pricing/.
Is the free version free for life?
Yes. xViz Visuals are free to use with all the Pro features unlocked in Microsoft Power BI Desktop in alignment with Power BI free Desktop concept. However, Pro License purchase is required to use the PRO features with Power BI Service, Premium, or Embedded Scenarios to be able to publish and share your Power BI reports with other usersBest Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
