Forum Discussion

brightcitrus's avatar
brightcitrus
Frequent Visitor
6 years ago

Remove unnecessary date points? DAX measures using ALLSELECTED

Hello PBI User Group,   I am facing a little challenge and I would greatly appreciate your help.   I created two measures (average and standard deviation) to create the two measures I really need...
Need Help
v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi brightcitrus 

 

Do you mean you'd like to remove the unnecessary axis values? please make sure the "Show items with no data" is not enabled in the axis filed.

also, you can use the filter pane, to filter the relative valuable dates of your axis. 

 

You can modify the slicer into the same periods with filter panel as well. 

 

brightcitrus's avatar
brightcitrus
Frequent Visitor
6 years ago

Hello v-diye-msft 

 

Thank you very much for your suggestions. I am aware of these filtering features, however the output is still not the desired output.

 

When I unselect the unnecessary date points, I am still left with a graph that is not responsive to the date filter since I am using ALLSELECTED. The graph does not "zoom out" or "zoom in" on the dates selected. Also, show items with no data is unchecked and the date points still show.

 

I think that there is somthing wrong with my formula. Could you please help me fix it?

 

Thank you very much for your help.

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi brightcitrus 

     

    Would you mind kindly sharing your dummy pbix that I can check it furtherly? thanks!