Forum Discussion

doppietta's avatar
doppietta
Frequent Visitor
8 years ago

selective slicer

Hi all,

 

I need to plot on clustered column chart the range distribution twice: the first one is the unfiltered version (made of by all the records in the table) and I need the second one to be dynamically adjustable based on a time slicer (I have a datetime column on my data model).

I don't know how to create a slicer that interacts only with the second dataset and not with the first one.

 

Thank you.

Regards,

Alberto

Need Help

8 Replies

    • doppietta's avatar
      doppietta
      Frequent Visitor
      8 years ago

      Hi v-sihou-msft,

       

      thank you for the quick reply.

      Unfortunately I don't think edit interaction function fits my needs.

      If you look at the following image, I'd like to slice only the aqua-coloured plot.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.

    • doppietta's avatar
      doppietta
      Frequent Visitor
      8 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi,

         

        Try this: NOTE - 'Table' is the name of your data table. Replace the word 'Table' in the formula below with your own table name (remember to use the quotation marks).

         

        Custom Measure = CALCULATE(COUNT('Table'[D_RHGL]),ALL('Table'))

         

        Then bind this to the charcoal series in your chart.