Enable Measure-based Pie Chart to filter Table

[JD193704]

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!

[Idrissshatila]

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]

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]

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.