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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
lduple4
Regular Visitor

time period over time period charts

I am having trouble building a chart that compares the sales prices for two different time periods.  For example, in excel, I have built a chart that compares the median sales price of homes from the last 12 months to the last 13-24 months.  I would also like to add a feature that shows the percentage change in these two time periods.  Also, I would like to be able to customize the time periods.  Maybe instead of comparing 12-month time periods, I will be able to toggle it to show the median sales price for the last three months compared to the prior 4-6 months.  Finally, I would like this to be automatically updated every time I open power bi.  So when I open the dashboard in four months, it will automatically compare the data from the date that I open the dash

1 ACCEPTED SOLUTION

Thank you for providing the sample data. That helps a lot with proposing a potential solution.

 

Here is the general idea how to tackle your expected output with customized measures.  You'll still need to add the formatting.

 

lbendlin_0-1659039148911.png

and here is the conditional formatting. Note: Only applied to Totals.

lbendlin_1-1659039185443.png

 

see attached for a boilerplate PBIX.

View solution in original post

6 REPLIES 6
v-henryk-mstf
Community Support
Community Support

Hi @lduple4 ,

 

Whether the advice given by @lbendlin  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry

lbendlin
Super User
Super User

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

lbendlin, I am not sure how to post a link to my data in excel.  Can I email you the data? 

Here is a screenshot of what I am looking to accomplish in power bi. However, I would like to be able to have one chart and just edit the dates, that way I can customize the time periods.  

lduple4_0-1658938987893.png

 

Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.

Thank you for providing the sample data. That helps a lot with proposing a potential solution.

 

Here is the general idea how to tackle your expected output with customized measures.  You'll still need to add the formatting.

 

lbendlin_0-1659039148911.png

and here is the conditional formatting. Note: Only applied to Totals.

lbendlin_1-1659039185443.png

 

see attached for a boilerplate PBIX.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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