cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

line & clustered visualization help

Hi, this is my first post, Im using the line and clustered visualization to present in the colums the total sales 2015 & 2016 and the line is for the % profit but its calculated based on both years. 

 

My cuestion is, how can i graph the % value just for 2016?

 

Thanks in advance for your support

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: line & clustered visualization help

Hi @josebernaldez,

 

To display line values only in 2016 year, you can create a measure to filter values in year 2016 like below:

 

Profit2016 = CALCULATE(SUM(Table1[Profit]),FILTER('Table1',YEAR('Table1'[Date])=2016))

 

q1.PNGq2.PNG

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: line & clustered visualization help

Hi @josebernaldez,

 

To display line values only in 2016 year, you can create a measure to filter values in year 2016 like below:

 

Profit2016 = CALCULATE(SUM(Table1[Profit]),FILTER('Table1',YEAR('Table1'[Date])=2016))

 

q1.PNGq2.PNG

 

 

Best Regards,
Qiuyun Yu

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