Forum Discussion

Nico_Schulze's avatar
Nico_Schulze
Frequent Visitor
3 years ago

secondary y-axis

Hello all, does anyone know if it is possible in Power Bi to create a chart with two bars that have a second y-axis? I am only shown the combination of bar chart and line chart, but I would like to ...
Need Help
asitm's avatar
asitm
Icon for Helper III rankHelper III
3 years ago

Hi Nic 

As Sandeep_PowerBI  suggested, a custom visual can help solve this. Since you need dual axis, you can use the Dual Y-Axis column custom visual by PBIVizEdit instead of the Lipstick Column custom visual.
You will need to adjust the offset and bar size for each column as shown in screenshots 2 and 3 in order to get to your desired visual.

Here is the appsource link for the viz -
https://appsource.microsoft.com/en-us/product/power-bi-visuals/yavdaanalyticspvtltd1628223732998.dualyaxiscolumnchart?exp=kyyw&tab=Overview


 

 

 

Nico_Schulze's avatar
Nico_Schulze
Frequent Visitor
3 years ago

Hey,

 

thanks a lot for your help! I would like to determine the minimum and maximum value of my y-axes myself. But unfortunately I can't find a function for that. This is done automatically. Do you know how this would work?

 

Many greetings
Nico

  • asitm's avatar
    asitm
    Icon for Helper III rankHelper III
    3 years ago

    Hi Nico,

     

    I modified the visual using the GUI editor at PBIVizEdit and below is link to the file (both the custom visual .pbiviz and the sample report .pbix) that allows you to fix y-axis range.

    https://drive.google.com/drive/folders/1icUte3Co12Ohpk52g7irkkiUyZ-q0gY9?usp=sharing

    Click on the auto range to toggle on or off. I noticed that at times it may need a double click instead of single click to toggle. not sure why.

    Overall, hopefully this solves your problem.

     

    Regards,
    AsitM