Forum Discussion
Using Multiple Slicers to change a value within a Column
- 1 year ago
Calculated columns and tables are calculated on semantic model refresh. You cannot use slicers to affect them
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.