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

How have a graph ignore data holes

Capture.PNG

 

 

I want to have the graph lines that I highlited not display if there is no data linked to them. 
Setting the X asis to categorical does not work as my original dates are incosistent and they skew the graph.
Help is appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: How have a graph ignore data holes

Can you post the Measure formula you are plotting?

 

It looks like you need to add an additional FILTER argument

 

Look here

http://community.powerbi.com/t5/Desktop/cumulative-sum/m-p/113572#M47911

 

Hope this helps! Smiley Happy

View solution in original post

3 REPLIES 3
Highlighted
Community Champion
Community Champion

Re: How have a graph ignore data holes

Can you post the Measure formula you are plotting?

 

It looks like you need to add an additional FILTER argument

 

Look here

http://community.powerbi.com/t5/Desktop/cumulative-sum/m-p/113572#M47911

 

Hope this helps! Smiley Happy

View solution in original post

Highlighted
Frequent Visitor

Re: How have a graph ignore data holes

Workable  =

 CALCULATE ( COUNTROWS (dr_summary), dr_summary[Status] = "OPEN", FILTER (
        ALL ( dr_summary[Due Date]),
        'dr_summary'[Due Date] <= MAX ( 'dr_summary'[Due Date] ))
)

I'll try out the solution in the post you suggested.

Highlighted
Frequent Visitor

Re: How have a graph ignore data holes

Genius. It worked !

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors