Forum Discussion

rvanderploeg's avatar
rvanderploeg
New Member
5 years ago
Solved

Limiting dates shown on stacked bar chart when using "show items with no data"

I have a stacked bar chart here with a count of each process completed on every given day as a way to track our progress.

The data looks like this:

DateProcess Title
10/2/21Process X
10/2/21Process X
10/4/21Process Y
10/4/21Process X
10/7/21Process Z

 

In this case, 10/2/21 would show a stacked bar with a count of 2 for process X, 10/4/21 shows a count of 1 for process Y, and another section of 1 for process X, etc.

The issue is that when I'm showing dates with no items, the graph continues to the end of the calendar year, and spans back to the beginning of the first calendar year for which there is an entry. This is extra annoying because we have several years worth of data, and you can't get PowerBI to start scrolled all the way to the right, so whenever viewing the plot, I have to scroll to the right to get to any actual data. In addition to this, filtering by date only hides data on specific dates without constraining the X axis of the chart.

Is there a way that I can constrain the X axis of the chart to show only, for example, the last 30 days  on the X axis?

  • Hi, rvanderploeg 

     

    Using slicer and filtering data in filter pane can all have an effect on the X axis. You can try it.

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.


    Best Regards,

    Community Support Team _ Janey

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

     

    You can try with slicer on date , with relative date option. There we are having options to last X days, years 

     

    Regards,

    Nidhya

    • rvanderploeg's avatar
      rvanderploeg
      New Member

      I've tried this and AFAIK it just hides data on the dates that get "filtered out", the X axis still continues to the end of the current calendar year.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support

    Hi, rvanderploeg 

     

    Using slicer and filtering data in filter pane can all have an effect on the X axis. You can try it.

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.


    Best Regards,

    Community Support Team _ Janey