Forum Discussion

ask's avatar
ask
Icon for Helper III rankHelper III
9 years ago

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...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
ask
Icon for Helper III rankHelper III
9 years ago

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

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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