Hide bar graph if Measure total is low

[Saniat]

Hi,

I am working on a HR Dashboard and one of my requirement is not to show breakdown of workforce when we are analysing low number of population.

For example: In the below example I am analysing 19.5 FTEs, but I would like to add a threshold that if my total FTE goes below 10, I will hide the entire Bar Graph.

It it possible ?

Thanks for the help.

[ppm1]

You can't really dynamically hide the visual, but you can make any value below 10 return blank. This assumes you've create a measure called Sum of FTE (not just dragged the FTE colulmn into the visual).

// will hide any bar <10

NewMeasure = var FTE = [Sum of FTE]

return IF(FTE>=10, FTE)

// will hide all bars if overall total <10

NewMeasure = var FTE = [Sum of FTE]

var overallFTE = CALCULATE([Sum of FTE], REMOVEFILTERS(Table[Function]))

return IF(overallFTE>=10, FTE)

Pat

[Saniat]

Hi @ppm1 

Thanks for the hint.

It works for the case where I have a fixed dimension in the Y-axis e.g. Function.

FTE_Privacy =

var FTE = SUM('1'[FTE])

var overallFTE = CALCULATE(SUM('1'[FTE]), REMOVEFILTERS('1'[Function]))

return IF(overallFTE > 20, FTE, BLANK())

But I am not sure how do I make it work when I am using Field Parameter to decide my Y-axis ?

Thanks in advance !

[ppm1]

Try putting ALLSELECTED() in place of REMOVEFILTERS('1'[Function]))

Pat