I am creating a visualization to show the trend of change. I have a date column and the date type is date. But in the option of Axis, there are only date and date hierarchy. How can we group the day, month and year like the picture below?
After turning off Concatenate in X-Axis, sort your visual by the value then sort it by Year/Month/Date etc as the concatenation doesn't seem to take effect unless the visual has been sorted by value first.
Hi Phil, @Phil_Seamark
I tried the column visulization. When I drill down to Month level, I can see the "Concatenate Labels". Noting happend after I turned it off.
But if I drill down to day level, I can not see the "Concatenate Labels".
Is there anything wrong in my setting?
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.