Jump to content
We've recently updated our Privacy Statement, available here ×
  • How to remove zero values from HTML5 stacked bar chart


    Jivan Phadtare
    • Features: Charts Version: v7.8.0 Product: Jaspersoft® Studio

    Issue :

    HTML5 stacked bar chart grouped by month and by tenant  having tenants value zero are showing up on the report. Zero values from staked bar chart needs to be removed.

    e.g. attached screenshot (Issue.png) has zero values in stacked bar chart which needs to be removed.

    Resolution :

    To remove zero values from stacked bar, below property need to be added.

    Kindly follow steps :

    1) Open Jaspersoft Studio and navigate to below path :

    Go to Window -> Preferences -> Jaspersoft Studio -> Properties

    Search for "com.jaspersoft.jasperreports.highcharts.function.properties.allowed" and set this property to true  (if this property already not present then kindly add it)

    2) Edit Chart Properties -> Chart formatting -> Advanced Formatting -> plotOptions -> bar -> dataLabels -> formatter -> use expression and feed it the following function (make sure add below function in double quotes) :


    "function(){ if(this.y > 0) return this.y; }"

    Screenshot for the same attached. ( "Resolution.PNG" )

     

    Result :

    After following resolution steps, zero values from stacked bar removed as per attached screenshot. ("Result.PNG")

     

     


    User Feedback

    Recommended Comments

    There are no comments to display.



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...