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

Dashboard representation through line chart

Hi,

 

I am having trouble figuring this one out. We have a dashboard that we normally update twice a month. I am trying to show, through a line chart, the progress we make on the outstanding volume of transaction we need to process. My problem is that for each month, the values are summarized therefore, at the end of the month, the result on the chart is the combination of the outstanding volume at the 15th and the 30th. I only what the chart to take in account the last value entered for the month.

 

Example: 

DateOutstanding ItemsResults on dashboard
September 15 2021500500 (which is the correct value of outstanding item at the time)
September 30 20216001100 (which is not the correct value we want to represent at the end of the month) We would like to show that the outstanding volume at the end of september is 600)

 

Thank you very much in advance.

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @Whoule ,

Here are the steps you can follow:

1. Create calculated column.

Month = MONTH('Table'[date])

vyangliumsft_0-1632211447743.png

2. Create measure.

Measure =
CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Month]=MAX('Table'[Month])&&'Table'[date] = MAXX(FILTER(ALL('Table'),'Table'[Month]=MAX('Table'[Month])&&'Table'[date]=MAX('Table'[date])),[date])))

3. Result:

vyangliumsft_1-1632211447746.png

Does this match your expected result

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

3 REPLIES 3
v-yangliu-msft
Community Support
Community Support

Hi  @Whoule ,

Here are the steps you can follow:

1. Create calculated column.

Month = MONTH('Table'[date])

vyangliumsft_0-1632211447743.png

2. Create measure.

Measure =
CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Month]=MAX('Table'[Month])&&'Table'[date] = MAXX(FILTER(ALL('Table'),'Table'[Month]=MAX('Table'[Month])&&'Table'[date]=MAX('Table'[date])),[date])))

3. Result:

vyangliumsft_1-1632211447746.png

Does this match your expected result

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

Greg_Deckler
Super User
Super User

@Whoule It sounds like Lookup Min/Max: Lookup Min/Max - Microsoft Power BI Community


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

@Greg_Deckler Thank you. Could you help identifying what term to put where in your measure formula?
Here is a picture of what the data looks like.

Whoule_1-1631888070213.png

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!