Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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
Solved! Go to 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.
and here is the conditional formatting. Note: Only applied to Totals.
see attached for a boilerplate PBIX.
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.
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.
Here is the google drive link:
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.
and here is the conditional formatting. Note: Only applied to Totals.
see attached for a boilerplate PBIX.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
121 | |
112 | |
59 | |
58 |