cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ask Member
Member

how to disable filter on date x-axis

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?

6 REPLIES 6
Super User
Super User

Re: how to disable filter on date x-axis

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


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
ask Member
Member

Re: how to disable filter on date x-axis

B.jpgc.jpg

 

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

Super User
Super User

Re: how to disable filter on date x-axis

@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.


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
v-ljerr-msft Super Contributor
Super Contributor

Re: how to disable filter on date x-axis

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? Smiley Happy

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

 

Regards

ask Member
Member

Re: how to disable filter on date x-axis

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

v-ljerr-msft Super Contributor
Super Contributor

Re: how to disable filter on date x-axis

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. Smiley Happy

 

Regards