Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
josiahfaas
Frequent Visitor

date grouping for x-axis

I have a data set with a date field that I wish to use for the x-axis. The date field includes timestamp.

 

When I move this field to 'Axis' and include 'Number of Records' on 'Value' there is a bar for every value. I'd like to group these by either year, quarter, or month, depending on the required presentation.

 

Is creating a date table and adding a relationship to it the only way to accomplish this? Coming from Tableau where there are approx a dozen preset options that can be utilized, it just seems silly that there is not more built-in functionality here.

 

Am I missing something?

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

No, you could also create some calculated fields for this, use FORMAT:

 

https://support.office.com/en-us/article/Custom-Date-and-Time-formats-for-the-FORMAT-Function-DAX-dc...

 

You can get quarter by creating a "m" FORMAT column and then using a nested IF statement or other means to separate out the values into quarters.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

No, you could also create some calculated fields for this, use FORMAT:

 

https://support.office.com/en-us/article/Custom-Date-and-Time-formats-for-the-FORMAT-Function-DAX-dc...

 

You can get quarter by creating a "m" FORMAT column and then using a nested IF statement or other means to separate out the values into quarters.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Thanks smoupre!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!