We have a scenario as below:
and the line plot is as below:
What we would like to have is there should not be gaps in between red and green...meaning it has to be green till it encounters red and vice versa. Is this achievable ? Please advice.
I'm thinking merge your table with a date table in Power Query and then use Fill Down on the result column to fill in the missing data. Then you could use Categorical and get a solid line with no gaps?
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Have you tried changing the X-Axis from Categorical to Continuous?
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Yes, tried to change from categorical to continuous. However results are not as expected, see below:
If the value is good then green should be displayed but red is continuing.
Thank you.
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
FabCon &SQLCon Highlights
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
