Bar chart with differents calcs and filters

[Anonymous]

Hi community,

I need create a bar chart with 3 columns, that the 1st bar is the highest value in datatable, ignoring the slicer of dates. The others 2 columns are the latest two dates of sliced period.

E.g., I have the following dataset:

date	value
01/01/2020	80
02/01/2020	90
03/01/2020	100
04/01/2020	70
05/01/2020	20
06/01/2020	20
07/01/2020	50
08/01/2020	15
09/01/2020	25
10/01/2020	55
11/01/2020	13
12/01/2020	13
13/01/2020	7

Based in dataset above, if I slicer the period 05/01/2020 to 10/01/2020 , the 1st bar must be 100 and the other two, 25 and 55, respectively.

Anybody help me in this case?

[Greg_Deckler]

Sure, for the first one, use MAXX with an ALL filter. For the other ones, you should be able to just use MIN and MAX or perhaps you need to use this pattern:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434

[Anonymous]

Hi, @Greg_Deckler.

This solution does not worked, because I need just 3 columns and using this solution sending by you, resulted in one  column for each date.