Forum Discussion
Anonymous
4 years agoNot applicable
Line and Stacked Column chart - hide specific data points
Hi Is there a way within a line and stacked column chart to hide some of the data (in this case, the bars) so I'm only showing the oldest and the latest data points Here's what I have ...
- 4 years ago
Hi, Anonymous ;
Such as Pragati11 said, however One thing is different, what I'm establishing here is the values of the earliest and latest dates.
Measure = var _max=CALCULATE(MAX('financials'[Date]),ALL(financials)) var _min=CALCULATE(min('financials'[Date]),ALL(financials)) return CALCULATE(SUM(financials[ Sales]),FILTER('financials',[Date] in {_max,_min}))Then change the data label.(close line's label and retain column's)
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
4 years agoNot applicable
managed to get it to work. thanks all