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
Resident 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
    Resident 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.