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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

I am not clear about what you want.  Do you want to show the total sales for ech of the past 60 months ended the month select by the user in the slicer.  So if a user selects Jan 2024, then there should be 60 columns in the column chart ending in Jan 2024?