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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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