What is the correct visual to display set of values within a range

[Anonymous]

I have certain values(say x) and I have another table which defines the maximum and minimum values. What will be the best visual to showcase my values and also that value falls within that range of Maximum and minimum values? any way by which I can also tell that if values have fallen beyond my range

[Fowmy]

@Anonymous 

Check out the Box-and-Whisker Plots: https://powerbi.microsoft.com/en-us/blog/visual-awesomeness-unlocked-box-and-whisker-plots/

[Anonymous]

@Fowmy 

Box and Whisker doesnt seem to answer my problem. I have like sensors data from different devices whose reading I am plotting in my graph. Now each device should give sensors reading within a range of max and minimum values.

I have kept my device Id in a slicer. Selecting a device ID I see my readings over a scatter plot. But I would also like to see what all readings have gone beyond the specified Maximum and Minimum readings.

1st Table:

Device ID	Readings
a11	111
a11	110
a11	211

table 2:

Device ID	Max read	Min read
a11	100	180
a12	120	130
a13	131	200

So thats how my table is and in same graph I will be seeing hown many times my a11 id has crossed the minimum and maximum reading

[v-jingzhang]

Hi @Anonymous 

You can set conditional formatting. For example, create a relationship between two tables on column Device ID and set its cross filter direction as Both. Then create below measure:

Flag = 
VAR _value = SELECTEDVALUE(Table1[Readings])
VAR _min = SELECTEDVALUE(Table2[Min read])
VAR _max = SELECTEDVALUE(Table2[Max read])
RETURN
IF(_value >= _min && _value <= _max, 1, 0)

Set conditional formatting on a field, format by Rules and select above measure as field. Just like below. You can format background color/Font color/Icons. 

You can also use this measure as a visual-level filter on a visual and set show items when value is 1 to only show values that are within the range (or show items when value is 0 to only show values that are out of range).

Attach a sample for your reference.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.