Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to highlight min and max total value in column chart where x axis represent year as well as label (Column in my dataset) used as small multiples. For simple column chart I can acheive it easily but for small multiple I am unable to solve this.
Here is my formula for min and max :
MinMax =
I want to highlight min and max for every label. Is it possible? If possible, kindly guide me towards the solution.
Here is my dummy data :
LabelYearValue
A | 2011 | 13 |
A | 2011 | 25 |
A | 2010 | 34 |
A | 2015 | 33 |
A | 2015 | 23 |
A | 2015 | 11 |
A | 2016 | 55 |
A | 2017 | 67 |
A | 2017 | 45 |
B | 2011 | 130 |
B | 2011 | 35 |
B | 2010 | 36 |
B | 2015 | 67 |
B | 2015 | 89 |
B | 2015 | 90 |
B | 2016 | 55 |
B | 2017 | 67 |
B | 2017 | 45 |
C | 2011 | 100 |
C | 2011 | 70 |
C | 2010 | 57 |
C | 2015 | 67 |
C | 2015 | 89 |
C | 2015 | 90 |
C | 2016 | 55 |
C | 2017 | 67 |
C | 2017 | 45 |
D | 2011 | 130 |
D | 2011 | 35 |
D | 2010 | 36 |
D | 2015 | 67 |
D | 2015 | 89 |
D | 2015 | 90 |
D | 2016 | 55 |
D | 2017 | 67 |
D | 2017 | 200 |
Here is the image. I want to highlight min and max in each quadrant.
Solved! Go to Solution.
I think this is what you are looking for. Assuming [Total] is a measure that SUMS your Value column.
Year Format =
VAR _YearMin = MINX ( ALLSELECTED ( 'Table'[Year] ), [Total] )
VAR _YearMax = MAXX ( ALLSELECTED ( 'Table'[Year] ), [Total] )
RETURN
SWITCH (
TRUE(),
[Total] = _YearMin, "Grey",
[Total] = _YearMax, "Red"
)
Make sure this measure data type is Text.
Then this measure get applies and the Columns > Colors conditional format.
Which gives us this.
I think this is what you are looking for. Assuming [Total] is a measure that SUMS your Value column.
Year Format =
VAR _YearMin = MINX ( ALLSELECTED ( 'Table'[Year] ), [Total] )
VAR _YearMax = MAXX ( ALLSELECTED ( 'Table'[Year] ), [Total] )
RETURN
SWITCH (
TRUE(),
[Total] = _YearMin, "Grey",
[Total] = _YearMax, "Red"
)
Make sure this measure data type is Text.
Then this measure get applies and the Columns > Colors conditional format.
Which gives us this.
Thanks @jdbuchanan71 for showing me the right path to acheive this. Exactly this is what I want. 👍
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |