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.
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.
Solved! Go to Solution.
I managed to do it by using the field 'Date' instead of 'Date hierarchy' as x axis, setting 'continuous' type as parameter.
I managed to do it by using the field 'Date' instead of 'Date hierarchy' as x axis, setting 'continuous' type as parameter.
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
Hi,
I'm using PowerBI in italian, btw i chose this visual:
and I set the option "Continuous" in this part:
Hey @mtrevisiol ,
you can use a cumulative function like DATESBETWEEN to get values for each day.
@selimovd thank you for the answer, could you explain more in detail how DATESBETWEEN can be useful for my purpose? Thanks.
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 |
---|---|
109 | |
106 | |
87 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |