Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
2 years ago
Solved

Clustered Column Chart Data Selection

I have Clustered Column chart that I have set to show a maximum of 60 months of data.  I do this by using YearMonth Field is in the last 60 months.  That currently means from today back 60 months.  ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, bdehning 

    First, thanks for marcelsmaglhaes's and Ashish_Mathur 's help. You can refer to their replies and if it doesn't work, refer to the following methods. Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.

    Put the Measure(Filter month) to the Filter Pane in the visual, and set 1 to filter.

     

    Filter Month =
VAR _end =
    TODAY ()
VAR _start =
    EOMONTH ( _end, -60 )
VAR _result =
    IF (
        SELECTEDVALUE ( 'Table'[Date] ) >= _start
            && SELECTEDVALUE ( 'Table'[Date] ) <= _end,
        1,
        0
    )
RETURN
    _result

     

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, bdehning 

First, thanks for marcelsmaglhaes's and Ashish_Mathur 's help. You can refer to their replies and if it doesn't work, refer to the following methods. Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.

Put the Measure(Filter month) to the Filter Pane in the visual, and set 1 to filter.

 

Filter Month =
VAR _end =
    TODAY ()
VAR _start =
    EOMONTH ( _end, -60 )
VAR _result =
    IF (
        SELECTEDVALUE ( 'Table'[Date] ) >= _start
            && SELECTEDVALUE ( 'Table'[Date] ) <= _end,
        1,
        0
    )
RETURN
    _result

 

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum