Forum Discussion
Helper IIIhow 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?
7 Replies
- vanessafvg
Community Champion
askcan you post a screenshot of the issue and an example of what you expecting?
askHi 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.
v-ljerr-msftMicrosoft Employee
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? :smileyhappy:
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. :smileyhappy:
Regards
