cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
zmukadam Frequent Visitor
Frequent Visitor

Latest date for each month in a bar graph

Hi,

 

I have to create a bar graph which shows the latest date for each month, I have currently created the chart with selecting the latest date but I would like this to happen automatically, is there a way of creating this?Bar chart.png

Any help would be great.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Latest date for each month in a bar graph

Hi,

In the picture, you will see the source data and the actual result.  You may download my PBI file from here.

Hope this helps.

Untitled1.png

2 REPLIES 2
Community Support Team
Community Support Team

Re: Latest date for each month in a bar graph

HI @zmukadam ,

In my opinion, I'd like to suggest you to add a measure to compare current date and corresponded last date and return flag. After these, you can use this measure as filter on visual level.

Measure =
VAR currDate =
    MAX ( 'Table'[Date] )
VAR _lastdate =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            YEAR ( 'Table'[Date] ) = YEAR ( currDate )
                && MONTH ( 'Table'[Date] ) = MONTH ( currDate )
        )
    )
RETURN
    IF ( currDate = _lastdate, "Y", "N" )

70.gif

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Super User
Super User

Re: Latest date for each month in a bar graph

Hi,

In the picture, you will see the source data and the actual result.  You may download my PBI file from here.

Hope this helps.

Untitled1.png