Reply
npetersen20
Frequent Visitor

Line Chart Time Series with No Data

Currently I have a Line and Cluster Chart with no data from January or February 2022. However, when building out the visual instead of excluding the data it shows the data as 0 on the chart. How would I go about fixing? "Show Items with No Data" is also deselected. Additionally, the line y-axis values are measures where the Column y Axis is a column and x-axis is a column as well.

npetersen20_0-1728498104225.png

npetersen20_1-1728498190947.png

 

 

1 ACCEPTED SOLUTION
npetersen20
Frequent Visitor

I found a solution, Wrapping my measure in an 2022 = If( *Calculation* = 0, Blank(), *Calculation*). This fixed the line chart issue.

 

 

View solution in original post

2 REPLIES 2
npetersen20
Frequent Visitor

I found a solution, Wrapping my measure in an 2022 = If( *Calculation* = 0, Blank(), *Calculation*). This fixed the line chart issue.

 

 

Hi, @npetersen20 

I'm glad you solved the problem you were experiencing on your own, and thank you for sharing your solution, which will help members of the community who have issues similar to yours to be able to find a solution more quickly.

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)