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
Paulyeo11
Impactful Individual
Impactful Individual

How to display only most recent 8 bar ?

Hi All

Paulyeo11_0-1602083604979.png

 

1 ACCEPTED SOLUTION

When you select a visual you can add additional fields onto it as 'Visual Filters'

 

Drop your date field onto the graph you wish to only show the most recent 8 days

 

Then change the date filter type to Relative Date Filter and then select 'Is in the last' and enter 8 days.

 

Apply the filter and I'd also use the eye icon so you hide that filter to avoid your users from changing it.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

7 REPLIES 7
Daviejoe
Memorable Member
Memorable Member

Change the filter type to Relative Date Filter





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

@Paulyeo11 follow this for relative date filter 
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range 

OR you can follow the below steps
relative date filer.png

Daviejoe
Memorable Member
Memorable Member

You can drop the Date field as a filter on the visual and select

 

Within the Last 8 days





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

@Paulyeo11  you can make use of filter pane and filter out the data which is required

When you select a visual you can add additional fields onto it as 'Visual Filters'

 

Drop your date field onto the graph you wish to only show the most recent 8 days

 

Then change the date filter type to Relative Date Filter and then select 'Is in the last' and enter 8 days.

 

Apply the filter and I'd also use the eye icon so you hide that filter to avoid your users from changing it.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Paulyeo11
Impactful Individual
Impactful Individual

Hi Sir

Too complicated for me. 

will try again next time.

Paulyeo11
Impactful Individual
Impactful Individual

Hi Dav 

thank you for sharing , i dont quite understand . can share a bit more ?

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.