Forum Discussion
Order of filter selection changes results
Anonymous
Are you using Month name in the X axis? You can use Month name as slicer but It is recommend to use Date column in the X axis with date hierarchy.Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Sometimes when you select an option from the filter, if that option is somehow related to other options in the same filter, it is possible that your first selection filters down the number of rows that would have been higher if only the second filter were selected.
In your case, selecting September first and then selecting months all the way to January, your filters might somehow filter down the data that other months would show. To be sure, you can check the row count on each filter item under the "filters on this page" section for the attribute of the month. Make a note of the row count against each month and start filtering by each month, if your current selection is affecting the row count of months not selected, then there is probably an unintended relationship that is causing that to happen and you may need to look into it.