cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Show day, Month and Year in a timeline format

Hi Experts,

 

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? 

 

2018_05_03_10_47_10_SolidQ_TSQL_Query_Analytics_Spanish_Microsoft_Power_BI_Community.jpg

Many thanks!

 

Best regards,

Tom

10 REPLIES 10
Highlighted
Microsoft
Microsoft

Re: Show day, Month and Year in a timeline format

Hi @TomLU123

 

Try turning off "Concatenate Labels" in the format properties.  I've attached a simple PBIX File that demonstrates.

 

image.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Highlighted
Super User IV
Super User IV

Re: Show day, Month and Year in a timeline format

In the X-Axis area of the formatting for the visual, turn off Concatenate labels, it is on by default. 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Super User II
Super User II

Re: Show day, Month and Year in a timeline format

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.






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa
Highlighted
Helper III
Helper III

Re: Show day, Month and Year in a timeline format

Hi Phil,

 

Many thanks for your reply!

I just checked but didn't find "Concatenate Labels" option. Is anthing I need set first? 

2018-05-03 12_56_50-DTA Hiring Manager Satisfaction Report (2) - Power BI Desktop.png

Highlighted
Helper III
Helper III

Re: Show day, Month and Year in a timeline format

Highlighted
Microsoft
Microsoft

Re: Show day, Month and Year in a timeline format

HI @TomLU123

 

Looks like the visual you have selected is the Area Chart.  You can only do this on certain visuals (like Column, or Column/Line)


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Highlighted
Helper III
Helper III

Re: Show day, Month and Year in a timeline format

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.

1234.png

But if I drill down to day level, I can not see the "Concatenate Labels".

123.png

 

Is there anything wrong in my setting?

 

Many thanks!

 

Best regards,

Tom

Highlighted
Microsoft
Microsoft

Re: Show day, Month and Year in a timeline format

HI @TomLU123

 

Are you drilling down using the double down arrows?

 

image.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Highlighted
Helper III
Helper III

Re: Show day, Month and Year in a timeline format

Hi Phil, @Phil_Seamark

 

No, I am using the the one besides it. 

Should I use the one you highlighted?

 

Many thanks!

 

Best regards,

Tom

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors