Forum Discussion

mpicca13's avatar
mpicca13
Icon for Resolver IV rankResolver IV
5 years ago
Solved

Add/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...
Need Help
  • amitchandak's avatar
    amitchandak
    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's avatar
amitchandak
Icon for Super User rankSuper User
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())

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amitchandak ,

I have a similar question where I need to filter the bins based on a numeric slicer. For example, if I want to show the bins whose values are greater than 40 only those bins must be visible.


Can you help me with this to achieve it?