Reply
New Member
Posts: 1
Registered: ‎12-07-2018
Accepted Solution

Line Chart

Hi,

 

I have one table with that data:

 

 

date	        balance
01/02/2016	1200
20/02/2016	500
01/03/2016	700
03/03/2016	1000
08/03/2016	1200
28/12/2016	800
03/02/2017	700
27/07/2017	300
05/09/2017	200
01/10/2017	1000
12/01/2018	300
12/02/2018	500
12/03/2018	600
12/04/2018	200
12/05/2018	300
12/07/2018	400
13/08/2018	900
15/08/2018	1200
01/09/2018	700

 

 

Each day we have the balance value.  It's not to be summed. For example. Balance of Feb/2016 is 500. Balance of Mar/2016 is 1200.

 

And so the year. The balance of year is the last value of that year. For example, balance of 2016 is 800.

 

I did a line chart with every value, that's ok my visualization by day.

 

Occurs that I need to filter it by MONTH and YEAR.

 

For example, for the YEAR, that is my chart:

 

cap30.JPG

 

Actually, I would like to get this result:

 

2018-12-04_16-46-22-d2bbbf954ba3aff62771de35286912f7.JPG

Because it is the LAST VALUE (not necessary the MAX) of that YEAR.

 

date         balance
28/12/2016   800       
01/10/2017   1000       
01/09/2018   700 

I would like to do that to MONTH too.

 

I thought about doing a new table for a MONTH, for YEAR with each of those values. Occurs that I have more than 100 of those examples. Each one is a client.

 

Is it possible to do a FILTER for that?  If not, how can I do that using columns?

 

 

Thank you,

 

 


Accepted Solutions
Highlighted
Super User
Posts: 3,737
Registered: ‎01-14-2017

Re: Line Chart

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled1.png

View solution in original post


All Replies
Member
Posts: 82
Registered: ‎11-16-2018

Re: Line Chart

Hi @andfx

 

maybe this helps

 

Measure = CALCULATE(SUM(Table1[balance]); FILTER(Table1;Table1[date] = MAX(Table1[date])))
Highlighted
Super User
Posts: 3,737
Registered: ‎01-14-2017

Re: Line Chart

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled1.png