Display continuous line in area chart

[mtrevisiol]

Hi everyone.

I've got this area chart:

On the X axis I put the calendary date, that is connected to all tables.

The orange measure represents the total sales per month for the selected item and it is a continuous line. The blue line represents the price of the same item paid to the suppliers and the purple line represents another kind of cost.

As you can see, the blue and purple line are not continuous, but they are visible only for the months in which there are some rows of purchases from the suppliers.

How can I show continuous lines also for these two fields? The ideal result would be:

So, for the months in which I have no purchases from the suppliers, I would like to see the last available price.

Thank you for the help.

[mtrevisiol · Accepted solution]

I managed to do it by using the field 'Date' instead of 'Date hierarchy' as x axis, setting 'continuous' type as parameter.

[danie_figueroa]

I am looking for the option to show continuously but it is not in the x or y options. could you show a photo please

[mtrevisiol]

Hi,

I'm using PowerBI in italian, btw i chose this visual:

and I set the option "Continuous" in this part:

[selimovd]

Hey @mtrevisiol ,

you can use a cumulative function like DATESBETWEEN to get values for each day.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[mtrevisiol]

@selimovd thank you for the answer, could you explain more in detail how DATESBETWEEN can be useful for my purpose? Thanks.