Showing results for 
Search instead for 
Did you mean: 
markoss92 Regular Visitor
Regular Visitor

Dynamic Grouping



I have a column with the probability of booking cancellation.  I want to create a slicer that allows the client to stablish a probability treshold that defines "Will cancel" and "Will not cancel" depending of the cancellation probability.


|---------O------------------------|                             Day              Reservation      Will Cancel           Will not cancel

0            0,3                                1                              01-04-19              30               5                                25

                                                                                   02-04-19             25                10                             15

So from 0 to 0,3 -> Will not cancel

0.3 to 1 -> Will cancel


The client can move the probability treshold and the categories Will/Will not Cancel must change


Thanks a lot!!

Community Support Team
Community Support Team

Re: Dynamic Grouping

hi, @markoss92 

First, you should know that calculated column and calculate table can't be affected by any slicer. you could create a measure instead of column.
1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.
here is reference:

Second, Use What if parameter in power bi to add a probability threshold and create a measure based on it.


Best Regards,



Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.