Forum Discussion

andreazambon's avatar
andreazambon
Helper V
3 years ago

Blank graph elements based on ISFILTERED() condition.

Hi there,    in a previous discussion we arrange to hide/show a graph putting a textbox on it, working on the fill color of the textbox:     Trasparenza_se_filtrato = IF(ISFILTERED(SAPScrapCaus...
Need Help
cThennakoon's avatar
cThennakoon
Frequent Visitor
3 years ago

You can use the below measure in the graph so it will blank the values when not filtered 

 

TotalKgs =
IF(ISFILTERED(Tabella1[Cause])=FALSE,BLANK(),SUM(Tabella1[kg]))
You can find the file I updated test_Conditional_Formatting.pbix