Forum Discussion

JD193704's avatar
JD193704
Frequent Visitor
2 years ago

Enable Measure-based Pie Chart to filter Table

Hello,

 

I have a table where I work with conditional formatting in a separate column. So, based on several conditions this column shows a certain color code (#008B00, #FF0000, #FFFF00, #BEBEBE). For my Pie Chart, I use measures to show the distribution of these colors:

PieChartGreen = COUNTX(FILTER(Table, ColorLogicMeasure = "#008B00"), ColorLogicMeasure)

 

I use this way because the coloring is based on dates and the dates can be changed by pre-selection in a slicer.

But with this implementation it's not possible to click on one section of the PieChart to filter the table. I tried to create a connection via the Legend field but it is not possible to use measures there.

 

Any idea on how to solve this problem?

 

Thank you!

Need Help

3 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    2 years ago

    Hello JD193704 ,

     

    try making this conditional formatting field as a calculated column in the main table that has the data, then you can use it to filter it.

    • JD193704's avatar
      JD193704
      Frequent Visitor
      2 years ago

      The problem is I was not able to make it work with a conditional column. The measure for the conditional formatting looks basically like this:

       

      Measure = 

      VAR Date1 = ...
      VAR Date_Changing = Measure_Deadline

      RETURN
      IF(Date1 > Date_Changing,...

       

      Is it possible to have a VAR defined in a column, that changes based on a slicer setting which changes the threshold for the Date_Changing? If you know what I mean...

      • Idrissshatila's avatar
        Idrissshatila
        Super User
        2 years ago

        Hello JD193704 ,

         

        no this won't work as a calculated column if there's an input taken from a slicer.

         

        and also in your case the measure won't let you filter the table.