Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
  • 1.  Supress Zero on Legends

    Posted 11 hours ago
    Hi,

    I have a cube with four dimensions: Period, Products, Version, and Measure. The Products dimension has more than 500 elements.
     
    I am building a line visualization with Period on the X-axis and Measure(Quantity) on the Y-axis, while using Products as the colour category. The cube contains sparse data across 24 periods, data is only available select for 6–8 months, with the rest remaining blank.
     
    Here's the challenge:
     
    If I apply zero suppression, the Period dimension on the X-axis shrinks to only the months with data.
     
    If I disable zero suppression, I can see all periods, but the legend expands to include all 500 products, making the visualization unusable.
     
    What I'm trying to achieve is: retain the full X-axis (all periods) while suppressing the legend to only show Products that have data.


     
    Is there an option in PAW (or a workaround) to suppress the legend elements without shrinking the Period axis?
     
    Thanks in advance for your help.

    Regards,

    J


    ------------------------------
    Jitesh Parmar
    ------------------------------