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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
CincyKidd
Frequent Visitor

Expanding a data set from fixed (30 days) to open (running data set)

My data is a running data set, meaning I started tracking on June 15th. I understand that I can use the Slicer function to break the data into months, is there a way to see the data set in its entirity, right now it looks like it is limited to 30 days.

 

pic3.png

 

Thanks for the help!

 

CincyKidd

1 ACCEPTED SOLUTION

The solution is to go into the "Date" field, dropdown and tick the "Date" vs "Date Hierachy".

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

@CincyKidd

 

Based on the information provided you have started tracking from June 15. And as on date we are at July 15. The day column i presume refers to the day portion (DD) of the date column.  June has only upto 30 days and July is not yet complete. Once you have the data until end july 31st, you will see the day 31 appearing.

 

When you say you want to see the data in entirety , can you share some more details on how you want the data to shown. By Month or by Day etc.

 

Cheers

 

CheenuSing

 

CheenuSing-

 

Thanks for the reply!

 

I would like to see all data, meaning from June 15 through today (whatever that will be. I can't figure out how to get that done!

 

Thanks again.

 

CincyKidd

Anonymous
Not applicable

@CincyKidd

 

Do you want the x-axis to show the dates like Jun-15, Jun-16, Jun-17 etc.

 

Please clarify

I would like the x axis to display all data points, say 6/15-7-19. It currently shows only 30 days, non concurrent, meaning June or July or a combination of June and July, but only 30 days at a time..

 

Thanks.

 

CincyKidd

Ok. I clearly have confused everyone here, since there are no solutions, which I find hard to believe.

 

My revised summary.

 

I have been collecting data from 4 machines and sometimes a machine will have up to 4 data points on a day, I have been collecting this data since 6/15 and I would like to see all the data points in a bar graph along the X axis. I have been helped to figure out how to show the mulitiple data points, now I just need to figure out how to display ALL the data. Right now I get only 30 or 31 day chuncks.

 

Thanks for the help!

 

CincyKidd

The solution is to go into the "Date" field, dropdown and tick the "Date" vs "Date Hierachy".

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors