Forum Discussion
mpicca13
Resolver IV
5 years agoAdd/Remove Bins in Bar Chart based on Slicer Selection
I have a bar chart that calculates percentages of negative reviews and groups them in increment ranges of 10%. so 5 bins in total in the visual (10-20%, 20-30%, 30-40%, 40-50%, >50%) There is al...
- 5 years ago
mpicca13 , Assume You are already using a measure (called as a measure or use the calculation in use in values of visual)
Have a new measure like
new measure =
var _max = maxx(allselected(Threshold),Threshold[Threshold])
return
if(max('High Negative'[Max]) >_max , [Measure], blank())
amitchandak
Super User
5 years agompicca13 , Assume You are already using a measure (called as a measure or use the calculation in use in values of visual)
Have a new measure like
new measure =
var _max = maxx(allselected(Threshold),Threshold[Threshold])
return
if(max('High Negative'[Max]) >_max , [Measure], blank())
mpicca13
Resolver IV
5 years agoWorked Like a charm, thanks amitchandak