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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Chris-VA
Regular Visitor

Change dates in Bar Graph

Within my organization, we have pay periods that start at 20, go to 26 and then start at 1 to 19 to end the year.  When creating a bar graph it normally will start at 1 and then go to 26.  I am trying to find out how to have it start at pp 20 then go to 26 and then 1 through 19.  Any ideas on how to change this to reflect in graphs?

 

Here is an example of what I see:

 

ChrisVA_0-1660240587560.png

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

try this - add another column with the right order

 

20 =1

21 =2

22 =3

...

26 = 5

1 = 6

2 = 7

 

etc.

 

Then use the "Sort a column by another column" feature.

View solution in original post

2 REPLIES 2
Chris-VA
Regular Visitor

Perfect, appreciate the help.

 

lbendlin
Super User
Super User

try this - add another column with the right order

 

20 =1

21 =2

22 =3

...

26 = 5

1 = 6

2 = 7

 

etc.

 

Then use the "Sort a column by another column" feature.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.