Forum Discussion
How to keep data showing in Area Chart using X-Axis Constant Lines
Hi ICW1972 ,
Based on the information you have provided, if the dataset itself is missing dates, this may result in a discontinuous area map. You might consider adding rows with zero or null metric values for these dates so that the area map will be presented continuously.
Or you can set the X-axis type to "Continuous" under the X-axis format option to achieve the results you are looking for.
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thanks for replying!
There is no missing data. What I am showing the two pictures in the post is that if you drag the date slicer node on the left to the right (max date), it just makes the data disappear. The data is there. If you drag the left button on the slicer to the left, it shows the data in that range.
The visualization should IMO resize itself to show the date range of the date slicer, removing any markers that are not within that date range. Instead, it just shows blank areas.
If the user says, "I want to see data between the two dates X & Y", then the visual should only show data AND markers for that time period. Instead, it seems designed to show markers regardless of what date filters are applied.