Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
HI Team,
We came across one requirement in which we need one column(Can be custom Column) for which value should be populated based on slicer range selection(Dynamically).
eg:
Dynamic Value/Custom column | |||
ID | Range | Value | Flag |
1001 | 1 | 24 | N |
1002 | 2 | 12 | N |
1003 | 3 | 45 | N |
1004 | 4 | 34 | Y |
1005 | 5 | 23 | Y |
1006 | 6 | 48 | Y |
Now Range is slicer from where based on range selection Flag column should assign Y or N dynamically. if range is falling between selection then Y else N.
Slicer range selected from 4 to 6 hence Flag column populated value as Y for the same.
We have tried with ISfiltered DAX function but the problem is , it is not working if we are creating this as custom column .
Thanks
Solved! Go to Solution.
@Anonymous
You need to create a measure, Columns will not work as they are not affected by the slicer filters.
=IF ( MAX(TABLE[RANGE] >= MIN(SLICER[COLUMN] && MAX(TABLE[RANGE] <= MAX(SLICER[COLUMN], "Y", "N")
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
You need to create a measure, Columns will not work as they are not affected by the slicer filters.
=IF ( MAX(TABLE[RANGE] >= MIN(SLICER[COLUMN] && MAX(TABLE[RANGE] <= MAX(SLICER[COLUMN], "Y", "N")
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
HI @Fowmy
Thanks for your response on the query.
We would like to know if we want to achieve interection with other visuals then This measure is not interacting.
Is there any way to achieve interaction?
Dynamic Value/Custom column | |||
ID | Range | Value | Flag |
1001 | 1 | 24 | N |
1002 | 2 | 12 | N |
1003 | 3 | 45 | N |
1004 | 4 | 34 | Y |
1005 | 5 | 23 | Y |
1006 | 6 | 48 | Y |
Eg: We have enabled relationship and visual interaction as well but after adding this Measure in visual , interaction is not happening.
In above example count Flag (Y) is 3 so on click on the same it should interact with others to show only rows with Flag = Y in table . Could you please let us know Is there any way to achieve this?
Thanks in Advance!