Forum Discussion
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). F...
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.
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...
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.