how to disable filter on date x-axis

[ask]

Hi ,

I have one name filter, and a bart chart.  Bar chart show by date and sales amount. by default. The date x-axis will show continue calandar date.  But after a name is selected, it only shows filtered date on x-axis. How to keep the calendar date stick to the x-axis?

[Anonymous]

Hi @ask 

Try enabling "Show items with no data":

[v-ljerr-msft]

Hi @ask,

Could you try using the formula below to create a new measure to calculate the sales amount, then use the measure as Value in the bar chart to see if it works in your scenario? 

measure = SUM ( 'Table1'[Sales Amount] ) + 0

Regards

[ask]

@v-ljerr-msftthe same. Couldn't dislay those dates with no data

[v-ljerr-msft]

Hi @ask,

Could you share a sample pbix file, so that we can better assist on this issue? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards

[vanessafvg]

@askcan you post a screenshot of the issue and an example of what you expecting?

[ask]

  Hi @vanessafvg I need the chart shown like blue one. But it gives me green one instead if I apply for a filter

[vanessafvg]

@ask what filter are you applying? obviously what every you are filtering it by removes the other rows, so what are wanting to keep and what are you wanting to filter out.