Forum Discussion

dwightman2176's avatar
dwightman2176
Frequent Visitor
2 years ago
Solved

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's avatar
    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
_AAndrade's avatar
_AAndrade
Icon for Resident Rockstar rankResident Rockstar
2 years ago

I think the problem is on "% Availability" measure. Put some IF function that only do the "% Availability" if Downtime has value.

Something like this:
IF(NOT(ISBLANK( [Downtime])), 1-SUM(Issues[Impact on Uptime (%)], BLANK())

  • dwightman2176's avatar
    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

     

    Thanks,

    David

    • _AAndrade's avatar
      _AAndrade
      Icon for Resident Rockstar rankResident Rockstar
      2 years ago

      Replace BLANK() to 0 (zero). I think it could solve the problem