Forum Discussion

Tasneem3298's avatar
Tasneem3298
New Member
2 years ago
Solved

Axis issue

I have a combination visual i.e. line and stacked column chart where as per the custom table parameter 't' and 'g' selection, the values are being passed in the visual.

For instance both the table as A,B,C,D,E,F as row values. If A/B is selected then the visual will be showing column otherwise line values using switch().

 

 

 



I'm experiencing an issue where if neither A or B is selected i.e. no bar bar values, it still shows random value on the primary y axis(left). 

I want it to either not display any value on the left whenever no bar selection is made and also to show the axis value depending upon the selection. 
i.e. if both the measures are of % type then left and right side axis shows the respective % value as per automatic axis range.
Same for column.




Here only % values are selected which have been passed in secondary i.e. neither A or B was selected in both the parameters.


Here B was selected in both the parameters. As Align 0 is off, no values are being shown on the right else random values are visible too.


Kindly help



 



  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Tasneem3298 ,

    I create a table as you mentioned.

    Then I put it into the visual.

    Currently, in Power BI, the value range of the vertical axis only follows the axis that it depends on.

     

     

     

     

    Best Regards

    Yilong Zhou

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Tasneem3298 ,

    I create a table as you mentioned.

    Then I put it into the visual.

    Currently, in Power BI, the value range of the vertical axis only follows the axis that it depends on.

     

     

     

     

    Best Regards

    Yilong Zhou

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