Forum Discussion
Filter Slicer based on Measure
Hi all, I’m trying to set the max value of a slicer based on the max value of a measure.
What you will find in the attached pbi (bottom), is a simple model where services have a total capacity available and contracts related to these services are consuming this capacity over time. As you will see from the matrix, this works perfectly fine. However, I would also like to be able to filter on the availability using a slicer. The min value of the slicer should always be zero, but the maximum would need to be the max value of "Monthly availability) which you see in the matrix. Somehow, I’m not able to get this to work.
Also … either I find a way to set the max value of generate series (of the slicers) dynamically, or I apply a filter to the visual with 0 & 1 for each value which falls in the range of the monthly availabily. I can’t get neither to work
Model:
The report:
So this max value of the slicer should be the max availability depending on the slicers set on date, location & type.
Hope this makes sense.
Thanks.
Hi wlknsnBI,
I think you may forget to config the interaction between these visuals and filters, you can take a look at the following sample if it is suitable for your scenario.
Regards,
Xiaxoin Sheng
5 Replies
you can't have two measures influencing each other - that would create a circular reference. However, if you can live with one of them being a calculated column then it would work (that's basically what you have done, you have created a calculated table based on the status of a measure BEFORE any other filters were applied).
Please explain the business question that you are trying to answer.
Hi there,
The aim is to filter the availability between a min & max value coming from a slicer. I can make the filtering work on the matrix, but I can't make the slicer automatically set it's min/max availability range based on the other slicers.
Similar to this approach: https://www.youtube.com/watch?v=AZAL-QPn5Zc
PS: The availability is basically the capacity of a service - quantity of the contract. The latter is dependent on dates, but also on all the other slicers from which you can filter certain attributes of the service.
HI wlknsnBI,
AFAIK, you can use measure filters to filter slicer data sources, but they not able to dynamically update current selections.
Regards,
Xiaoxin ShengSure you can: I'm doing what's done here: https://youtu.be/AZAL-QPn5Zc
Simply can't get the virtual table to work like in my case.
Hi wlknsnBI,
I think you may forget to config the interaction between these visuals and filters, you can take a look at the following sample if it is suitable for your scenario.
Regards,
Xiaxoin Sheng
