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

Dynamic Grouping

Hi! 

 

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!!

1 REPLY 1
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.
Notice:
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:
https://community.powerbi.com/t5/Desktop/Different-between-calculated-column-and-measure-Using-SUM/t...
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

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

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

 

Best Regards,

Lin

 

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.