cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TomLU123
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
danextian
Community Champion
Community Champion

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!
"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa
Greg_Deckler
Super User
Super User

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!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Phil_Seamark
Microsoft
Microsoft

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!

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

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!

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

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!

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

HI @TomLU123

 

Give it a crack and let me know how you get on. 🙂


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

Proud to be a Datanaut!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.