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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
onevagi
New Member

Time Frame

Hi,

 

I have column which includes timeframe of 30 minutes for a day (Example: 00:00:00, 00:30:00, 01:00:00, 01:30:00.... till 23:30:00). I have created a Line and clustered column chart, the timeframe is in the X-Axis and I need the timeframe only from 08:00 to 20:00, So basically I need timeslice of the timeframe which I have. Any solution would be of great help. Thanks.

 

Kind Regards,

Omkar

1 ACCEPTED SOLUTION
Alican_C
Resolver II
Resolver II

You can use the following steps:

  1. Create a new calculated column to mark the rows that fall within the desired timeframe.

  2. Filter the visual by the use of new column

 

1. Creating the calculated column:


IsWithinTimeframe = IF(HOUR([TimeColumn]) >= 8 && HOUR([TimeColumn]) < 20,1,0)

 

2. Filtering the data:

 

  • Go to the "Filters" pane.
  • Drag the new IsWithinTimeframe column to the "Filters on this visual" area.
  • Set the filter to only include rows where IsWithinTimeframe is 1.

 

 

View solution in original post

2 REPLIES 2
Alican_C
Resolver II
Resolver II

You can use the following steps:

  1. Create a new calculated column to mark the rows that fall within the desired timeframe.

  2. Filter the visual by the use of new column

 

1. Creating the calculated column:


IsWithinTimeframe = IF(HOUR([TimeColumn]) >= 8 && HOUR([TimeColumn]) < 20,1,0)

 

2. Filtering the data:

 

  • Go to the "Filters" pane.
  • Drag the new IsWithinTimeframe column to the "Filters on this visual" area.
  • Set the filter to only include rows where IsWithinTimeframe is 1.

 

 

Hi,

 

Thank you so much for the help. It worked. Cheers 🙂

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors