Graph/Table showing more dates than needed on x-axis

Hello everyone. I'm hoping someone can help a bit of a Power BI novice here. I'm trying to build a visual using a Line and Clustered Column chart. The chart should contain the last 6 full calenda...

Need Help

dwightman2176
2 years ago
Thanks again . I played around with your suggestion and eventually came up with the following:
6-Month Availability % =
var _MinDate = TODAY()-184
var _MaxDate = TODAY()
RETURN
IF(
ENDOFMONTH(
Issues[End Date.[Date]) <= _MinDate,
BLANK(),
IF(ENDOFMONTH(Issues[End Date].[Date]) > _MaxDate,
BLANK(),
'Issue Measures'[% Availability]
))
Its not the perfect solution as it only works on a report looking at the past 6 months, but it will do for now until we can come up with something more flexible.

Thanks again for your help,
David

dwightman2176

Frequent Visitor

2 years ago

Thanks _AAndrade . That has almost solved it. Definitely a step forward. The issue I am left with now is where there is no downtime in a given month, that month is not presented in the visual, whereas I would like it to just show as being blank. As you can see in the attached - December is not presented on the visual