Using Multiple Slicers to change a value within a Column

[Lewis130719]

Hi, 

I have a table within Table View where there is a set of values between 1 - 100 and I would like to create a new column (not a measure) within this table. This new column would need to reference 2x diferent slicers (Slicer 1 and Slicer 2) so that if either of the slicers is updated by a user, then the results in Column 2 would be updated. 

Column 1	Column 2  (to be created)
10	Low
15	Low
16	Low
38	Medium
40	Medium

Slicer 1	Slicer 2
Condition: <20 = "Low"	Condition: <40 = "Medium"

[v-tsaipranay]

Hi @Lewis130719 ,

Thank you for reaching out to the Microsoft fabric community forum. Also thank you @Deku  for your input.

I understand you're looking to create a dynamic column that updates based on slicer selections (e.g., "Low", "Medium", etc.), but it's important to note a limitation in Power BI's engine:

• Calculated columns are static and are only recalculated during data refresh or model updates. As such, they cannot respond to slicer selections.

If your goal is to dynamically label values based on slicer inputs, I’d recommend using a measure instead and displaying the result within a visual (like a matrix or table), where the slicer selections can drive logic using DAX.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thankyou.

[Deku · Accepted solution]

Calculated columns and tables are calculated on semantic model refresh. You cannot use slicers to affect them