cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Assign value based on slicer Range selection

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
IDRange ValueFlag
1001124N
1002212N
1003345N
1004434Y
1005523Y
1006648Y

 

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

 

 

 

 

1 ACCEPTED SOLUTION
Super User IV
Super User IV

@shubham_002 

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 🙂

YouTube  LinkedIn






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn

View solution in original post

2 REPLIES 2
Super User IV
Super User IV

@shubham_002 

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 🙂

YouTube  LinkedIn






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn

View solution in original post

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
IDRange ValueFlag
1001124N
1002212N
1003345N
1004434Y
1005523Y
1006648Y

 

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! 

 

 

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors