Showing results for 
Search instead for 
Did you mean: 
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 :




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?


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:


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

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.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors