Forum Discussion
LamSar
Helper III
Helper IIIGrouping / binning in a measure
Good afternoon, I need help with grouping/binning. I have this slicer: The values are between 0 and 53 Is there any way that I can group the values using a measure? I only want...
Hello,
Thank you for your answer.
I can't add a conditional column via Power Query, because I'm using a tabular model (live connection).
mahenkj2
Solution Sage
Solution SageHello LamSar ,
I believe a measure in a slicer would not be possible, the reason is measure is calulated at run time.
I think, two ways possible. One is to add such additional column in source table itself. This is simple to implement, if you have control over source.
Second is to create a dimension table containing these numbers and relate with the fact table. Use dimension table's column in slicer. This dimension table can be created in power bi locally, no need to convert anything at source.
Hope it helps.
LamSarHelper III
Helper IIIOk. Thank you for your message!