Forum Discussion
claireberry
Helper I
1 year agoData suppression for a stacked column chart
Is it possible to have suppression be reflected in a stacked column chart? So if some count is not 0 and fewer than 10, have the chart label in a stacked column chart display the character "S"? exa...
- 1 year ago
pls see the attachment below
ryan_mayu
Super User
1 year agoI created two measures
Measure =
VAR _sum=sum('Table'[Column2])
return if(_sum>=0 && _sum<10,0,_sum)
this measure to display 0 if the value is between 0 to 10
measure2 =
IF(
[Measure]=0,
"S",
FORMAT([Measure],"#.##")
)
this measure will be added to detailed to display S instead of 0
claireberry
Helper I
1 year agoHi ryan_mayu
Thank so much for the V3. Can you please elaborate on why in the solution V3 isn't showing the blanks in the gender legend? I tried to implement the solution in my set of data, it shows blanks in the gender in the bar graph. thank you