Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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))
Best Regards,
Qiuyun Yu
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))
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |