topic Using Multiple Slicers to change a value within a Column in DAX Commands and Tips

Using Multiple Slicers to change a value within a Column

Lewis130719 — Tue, 06 May 2025 19:00:03 GMT

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"

Re: Using Multiple Slicers to change a value within a Column

Deku — Tue, 06 May 2025 22:52:09 GMT

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

Re: Using Multiple Slicers to change a value within a Column

Anonymous — Wed, 07 May 2025 09:46:53 GMT

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.