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.
hey guys
hopefully someone can give me a hand with the following question :).
i have the following dataset :
i placed the rolling total of the final price and a date count of the acq date column to measure how many apartments were sold over time.
the graph looks currently like so :
i'd like to show another line displaying the value of the remaining apartments by using the asking price collumn.
problem is i cant figure the measure syntax because first it'll have to check if the x axis period is before the acq date and based on the answer it'll have to sum the asking price column.
example : if the X axis filter is on Q4 2018 it should sum the asking price column on rows where there is no Acq date and rows where the Acq date is after 31/12/2018.
many thanks in advance!!!
another one, anyone knows how i can change the x axis display so it'll show only the years but with quarterly line markers and columns?
Hi , @orihait
I'm still confused about your demand.
For this issue, could you please share your PBIX/some sample data and expected result to me if you don't have any Confidential Information?
You can upload your .pbix file to OneDrive and share it with me if it is convenient.
And for your second question ,maybe you can refer to this article:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-customize-x-axis-and-y-axis
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |