Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ...
Need Help
Show and Tell
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 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's avatar
Anonymous
Not applicable
3 years ago

Thanks for the above. It partially worked....

  • for some reason, the line is not displaying (i've checked the various axis to make sure what's meant to be 'on' is on)
  • I'm wanting to chart a set date range, basically the last 13 months (e.g. aug 21 to aug 22), but when I change this, the 'min' data point disappears (I guess because the formula is taking the oldest date in the entire file as opposed to the oldest date that I want to chart)
  • For some reason, I don't have the FX option within the column sections when it comes to change the columns to 'white' (to hide them)