cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
smithD0 Frequent Visitor
Frequent Visitor

Date not showing properly on X Axis

I am having difficulty with my x axis showing a concatenated date label.  If I drill down into the heirarchy I can see the month, and the day, but none of the data is concatenated.

 

The x axis is set as type "Categorical", Concatenate lables is "On".  I've tried using the date column from the current table, and also a custom column from my date table.  This issue seems to be arbitrary, but I know that's impossible.  Any help would be greatly appreciated.

Screen Shot 2019-09-04 at 4.01.02 PM.pngNo year data concatenated.

Screen Shot 2019-09-04 at 3.56.23 PM.png

1 ACCEPTED SOLUTION

Accepted Solutions
Icey New Contributor
New Contributor

Re: Date not showing properly on X Axis

Hi @smithD0 ,

For Drill down and Drill up, you can refer to this article.

1. When you do not select the drill-down icon to turn it ondrill down.png , the visual will show overall data like visual 1. So, ‘No year data concatenated.’

2. When you select the drill-down icon to turn it ondrill down.png , the visual will show specify data, for example year 2018 you choose like visual 2. Then, year is not required.

3. In addition, if you want to show data both year 2018 and 2019, you can put Date Hierarchy in Legend like visual 3.

Date not showing properly on X Axis 1.PNGDate not showing properly on X Axis 2.PNGDate not showing properly on X Axis 3.PNG

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Icey New Contributor
New Contributor

Re: Date not showing properly on X Axis

Hi @smithD0 ,

For Drill down and Drill up, you can refer to this article.

1. When you do not select the drill-down icon to turn it ondrill down.png , the visual will show overall data like visual 1. So, ‘No year data concatenated.’

2. When you select the drill-down icon to turn it ondrill down.png , the visual will show specify data, for example year 2018 you choose like visual 2. Then, year is not required.

3. In addition, if you want to show data both year 2018 and 2019, you can put Date Hierarchy in Legend like visual 3.

Date not showing properly on X Axis 1.PNGDate not showing properly on X Axis 2.PNGDate not showing properly on X Axis 3.PNG

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Icey New Contributor
New Contributor

Re: Date not showing properly on X Axis

Hi @smithD0 ,

I find this video: Power BI - Pretty X-Axis for Hierarchies. And it shows what you want. What you need to do is to keep "Concatenate labels" off.

video.PNG

Best Regards,
Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 245 members 2,562 guests
Please welcome our newest community members: