Forum Discussion
selective slicer
Hi,
You will need to create a new custom measure that ignores any filters set on the page. This can be done using the CALCULATE() function. Your aqua series can be linked to your core data, and your charcoal series can be linked to the new measure. This will mean that whenever you apply filters, the aqua series will be filtered but the charcoal series will stay as it is.
If you can post an example of your data structure, I (or another helpful member) can give you an example CALCULATE() function to use.
Hi Tobias,
it could be very useful for me because I'm at the very beginning with powerbi.
This is my data model:
DAYTIME is the field used in the slicer
RHGL_CUSTOM_RANGE2 is used to build tailored bins
Period is the legend
D_RHGL is the value to be aggregated (count) over the ranges.
Thank you,
Alberto