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 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?
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
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.
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |