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
dwightman2176's avatar
dwightman2176
Frequent Visitor
2 years ago

Thanks again _AAndrade . That fixes the December issue, but re-introduces the other dates into the visual

 

Thnaks

David

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

Probably to do what you want, you need to see the min and max date of the x-axis that has value and after apply the measure.
For example:
VAR _MinDate = CALCULATE(MIN(Date), [measure] <>0)
VAR _MaxDate = CALCULATE(MIN(Date), [measure] <>0)
RETURN
IF(
   Selectvalue(Date) >= _MinDate && Selectvalue(Date)<= MaxDate,
   [measure],
  Blank()
)

Probably the measure that I wrote need to fix some issues but the idea is this.

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

      You just need to dynamically configure the _Min and _Max variables according to your model. That's why I used calculate.