Forum Discussion

LamSar's avatar
LamSar
Icon for Helper III rankHelper III
4 years ago
Solved

Grouping / 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...
Need Help
Show and Tell
Tips and Tricks
  • LamSar's avatar
    LamSar
    4 years ago

    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).

LamSar's avatar
LamSar
Icon for Helper III rankHelper III
4 years ago

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's avatar
mahenkj2
Icon for Solution Sage rankSolution Sage
4 years ago

Hello 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.

  • LamSar's avatar
    LamSar
    Icon for Helper III rankHelper III
    4 years ago

    Ok. Thank you for your message!