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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
BigLo
Helper II
Helper II

Date Format Quarter/Year

Hi,

I've got a dataset where the date fields are 'Year' and 'Quarter'.
I merge the two columns to have a "YYYY / QX" format.
But when I want to use this field as a date axis, the order is inconsistent.
I tried to convert it to text format, '2010/Q1' is before '2020/Q2' but the order is still the same.
Is there a Standard Date Format for Quarter/Year? Is there another method?

 

BigLo_0-1611576982426.png

BigLo_1-1611577035285.png

 

1 ACCEPTED SOLUTION
Geradav
Responsive Resident
Responsive Resident

@BigLo 

 

You need to use the "Sort by column" feature in Power BI to sort your "Year Quarter" column by another one.

Create another column containing your year and quarter in the format YYYYQ (e.g. 20203 for the third quarter of 2020) as a number data type. This column can, later on, be hidden in the model and will only be used to sort the "Year Quarter" column

When selecting the column you want to sort, the Column tools tab appears in the ribbon.

Geradav_0-1611579471483.png

Click on Sort by column and select the numeric column you created in the format YYYYQ.

 

Hope that helps. Let us know.

 

David

 

 

View solution in original post

2 REPLIES 2
Geradav
Responsive Resident
Responsive Resident

@BigLo 

 

You need to use the "Sort by column" feature in Power BI to sort your "Year Quarter" column by another one.

Create another column containing your year and quarter in the format YYYYQ (e.g. 20203 for the third quarter of 2020) as a number data type. This column can, later on, be hidden in the model and will only be used to sort the "Year Quarter" column

When selecting the column you want to sort, the Column tools tab appears in the ribbon.

Geradav_0-1611579471483.png

Click on Sort by column and select the numeric column you created in the format YYYYQ.

 

Hope that helps. Let us know.

 

David

 

 

Anonymous
Not applicable

Even alphanumerical these fields should be ordered.

Check you order settings in the visual. Most likely the setting is order by the (Y-axis) values.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.