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
hugomarquez
Frequent Visitor

Can Graphs through time show the most recent period at the right then scroll to left to it's history

Hello, If someone can help me, would like to know how to show, in a Bar Chart that goes through several months/years and has a horizontal scroll bar, the last months to the right, and if its necessary to see the history then scroll to the left. This in order to view the most recent data first instead of the oldest first.

 

Graph Through Time

https://1drv.ms/u/s!AoVKuGR4By59g-60YIxb1DBXcotfZWk?e=bZzMlc

9 REPLIES 9
Anonymous
Not applicable

im interested in this solution too 🙂

Hi @hugomarquez ,

 

Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Hello Frank, any news about a solution to my request would be appreciated!

Hi @hugomarquez ,

 

Sorry for my late respond. Please sort your date column like this.

 

Capture.PNG

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Hello, I found a photo of a graphs that emphadieses the solution I am looking for, if anyone can help I would appreciated it.

 

Graphs through time show recent period at right.jpg

Hello Frank, any other suggestion about a solution to my request would be appreciated!

Hello Frank, any other suggestion about a solution to my request would be appreciated!

Hello Frank,

Thanks for your response, your suggestion was my first choice, which does not solve the problem because the you get confused in the growing sales by period. If I sort from date descending order, it all seems as Sales (and costs) are going down, which definitely is not the case! Also imagine if the Forecast is presented as descending date order, it would seem you better forget business instead like it is really growing! I know it’s a matter of perception, but it is so important to see the growth, and to be able to see the most recent dates first! I hope PowerBI gets a “show right/left side of a graph” feature soon! If so, please let me know!

Yours truly,

Hugo Márquez

Hello Frank,

 

Thanks for your quick response, yes, I can upload the sample data and link it below. Once you open the PBIX file, in both Bar Charts I would like to see the right months (most recent ones) when opening the file or it's Web Publication. 1. The First Bar Chart has all the History since 2016, but it's much more relevant to see 2019 and its months first, then perhaps scroll back to the left as an option. 2.. The Second Bar Chart has 24 months Sales Forecast by Product, which is the main point of that Graph to see the future first, then perhaps scroll back to the left as an option.

 

PBIX File:

https://1drv.ms/u/s!AoVKuGR4By59g-60Yg16YpZ9ykXxJDk?e=gwDdbU

 

Sample JPG:

https://1drv.ms/u/s!AoVKuGR4By59g-60Yz_UNSIV7vdBxHY?e=ID00Dn

 

Hugo Marquez

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.