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.
In the X-Axis area of the formatting for the visual, turn off Concatenate labels, it is on by default.
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 October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!