cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AparnaJ Frequent Visitor
Frequent Visitor

Continuous plotting

We have a scenario as below:

Data 091719.PNG

 

and the line plot is as below:

 

Plot.PNG

 

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.

3 REPLIES 3
Super User
Super User

Re: Continuous plotting

Have you tried changing the X-Axis from Categorical to Continuous?


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

AparnaJ Frequent Visitor
Frequent Visitor

Re: Continuous plotting

Yes, tried to change from categorical to continuous. However results are not as expected, see below:

 

Plot 1.png

If the value is good then green should be displayed but red is continuing.

 

Thank you.

 

 

Super User
Super User

Re: Continuous plotting

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?


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)