Forum Discussion

mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
4 years ago
Solved

Prevent visual from limiting to months with data

For example, here is the unfiltered chart, with the full date period (Feb 2018 - Oct 2021)

 



If I limit to say Customer A, then the chart updates to only those months that Customer A has associated info  (Feb 2018 - Dec 2020)



I don't want it to do that, I want the chart to, regardless of filters, show Feb 2018 - Oct 2021, just all those later columns would be empty, as there's no data for Customer A in those later months.  i.e. - the customer filter still affects the chart, it just doesn't limit the date range. 




  • Got it. It's the "Show items with no data"

     

    Which when Googling - lots of issues with "Show items with no data not working" - as it's not in one of my visuals, but that's a seperate topic, i think I can figure out. 

     

3 Replies

  • mmace1's avatar
    mmace1
    Icon for Impactful Individual rankImpactful Individual

    Got it. It's the "Show items with no data"

     

    Which when Googling - lots of issues with "Show items with no data not working" - as it's not in one of my visuals, but that's a seperate topic, i think I can figure out. 

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi mmace1 

    I think you can change the scale options from Auto to a fixed scale in 'Format/Paintbrush' menu.

     

    Hope this helps.

     

    If you think I answered your question, please accept it as a solution.

     

    Thanks

    • mmace1's avatar
      mmace1
      Icon for Impactful Individual rankImpactful Individual

      Anonymous  For the Y-axis yes, but not the X-asis.