Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a line chart used to plot pH readings over time. I have two sensors. One sensor stopped reading on a certain date, and another started reading later. I have a line chart used to plot both. Even though the first sensor has null values, the line chart shows a straight horizontal line based on the last value available. How can I remove this line?
The values are null
Thanks for your help.
Line chart tries to connect values if it's null. You may suppliment nulls as zeros or maybe you conditionally change the color of that portion
User | Count |
---|---|
59 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
39 |