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

Bar chart scroll till the end

Hello,

it sounds like a simple thing, but I really didn't find anything about it. 

Is it possible that a bar chart by default always starts at the end of the date dimension and not the beginning?

Its a little bit annoying for the user to always need to scroll until the end to see whats up today. Using a "fixed" filter on the filter panel on the otherhand will automatically filter everything out which still needs to be seen. 

Thank you in advance.

Best. 

1 ACCEPTED SOLUTION

Hi, @Applicable88 

Sorry, PowerBI currently does not support setting the default scroll position.

 

If the time range covered on the x-axis is very long, you can consider adding a slicer for manual filtering. The custom visual "Timeline 2.4.0" would be a good choice.You can filter data for a period of time through this slicer (based on year/month/week/day)

62.png

63.png

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
SivaMani
Resident Rockstar
Resident Rockstar

@Applicable88 ,

 

You can sort the bar chart in descending order. For more details - https://docs.microsoft.com/en-us/power-bi/consumer/end-user-change-sort

 

@SivaMani , thats very unfortunate to solve it like that. For othere dimension it might be okay, but for Date dimensions its an unsual view. 

@Applicable88, Okay. Can you share your current visual and how you wanted to change it?

 

Hello @SivaMani thanks for your effort.

Here an example of data that reach back to  2017/2018:

Applicable88_0-1624274218575.png

Year and calendar week you can see here. And at the bottom you can see scrolled to the end until todays european calendarweek of 2021/25.

 

When the user is opening the chart/report it always starts at the very beginning. The only thing I could do so far is to limit it with the fixed "filter panel" where I limit the length of data using relativ time of "last 6 months":

Applicable88_1-1624274383144.png

 

For instance when the user wants to see older than last 6 month its not possible anymore. So I would prefer to have all time range in there, but the chart starts at the newest dat on the right side.  Using a workaround to make the order descending from left is really unsual for the eyes, since no report in the cooperate business would do so, with time dimension. 

Best.

 

Hi, @Applicable88 

Sorry, PowerBI currently does not support setting the default scroll position.

 

If the time range covered on the x-axis is very long, you can consider adding a slicer for manual filtering. The custom visual "Timeline 2.4.0" would be a good choice.You can filter data for a period of time through this slicer (based on year/month/week/day)

62.png

63.png

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.