cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Community Blog

Community Blog

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

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors