cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

conditional sum on line and stacked column chart

hey guys 

hopefully someone can give me a hand with the following question :).

i have the following dataset :

 

Capture.PNG

 

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 :

 

capture2.PNG

 

 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?

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: conditional sum on line and stacked column chart

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.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors