Forum Discussion
Amount clustered - Help needed
- Anonymous4 years ago
Hi omelei86 ,
Power BI doesn't support us to add a measure in Slicer. I suggest you to create a cluster calculated column by dax and create a slicer by this column.
Cluster = IF('Table'[Amount]<25,"€ 0 < € 25",IF('Table'[Amount]<50,"€ 25 < € 50","€ 50 < € 100"))Result is as below.
You may refer to below blogs for more details about the differences between measure and calculated column.
For reference:
What is the difference between Power BI calculated columns and measures?
Power BI Measures vs Calculated Columns
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi omelei86 ,
Power BI doesn't support us to add a measure in Slicer. I suggest you to create a cluster calculated column by dax and create a slicer by this column.
Cluster =
IF('Table'[Amount]<25,"€ 0 < € 25",IF('Table'[Amount]<50,"€ 25 < € 50","€ 50 < € 100"))
Result is as below.
You may refer to below blogs for more details about the differences between measure and calculated column.
For reference:
What is the difference between Power BI calculated columns and measures?
Power BI Measures vs Calculated Columns
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.