In the attached file I have a table with two columns a and b. Column a has dates formatted as months, that is "mmm" (Jan, Jan, Jan, Jan, Feb, Feb, Feb, Feb), and column b formates the dates in column a with the TEXT function as =TEXT( [@a], "mmm" ). The columns look the same, but the slicers for the columns behave different. The slicer for column a shows only one line when sorted for Jan or Feb. And the slicer for column b shows all the lines and are correct. Why is that?
Thanks in advance!
Bookmarks