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