Data suppression for a stacked column chart

[claireberry]

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"?

example:

pick stacked column chart

x-axis ---- Jurisdiction

y-axis ---- Counts (if this count is not 0 and fewer than 10 then the chart would display "S")

Thank you. 

[ryan_mayu]

@claireberry 

we can't do this in a normal way.

this is the sample data i used

stategender

A	M
A	M
A	F
A	F
B	M
B	M
B	M
B	M
B	M
B	M
B	F
B	F
B	F
B	F
B	F
B	F
B	M

I did the data transform in PQ and use DAX to create a new column

and do some settings on the chart

pls see the attachment below.

[claireberry]

Thanks for another solution. Is this the only way to achieve the bar chart with the gender legend? My data is too big to do that;I also don't understand the logic behind it. Would sample data like this below also need a transformation first like you did? Thank you

[ryan_mayu]

pls paste the data in the reply(not the screenshot)

[claireberry]

state	count	gender
A	1	F
A	1	M
A	1	F
A	1	M
A	1	F
B	1	M
B	1	F
B	1	M
B	1	F
B	1	M
B	1	F
B	1	M
B	1	F
B	1	M
B	1	F
B	1	M
B	1	F
B	1	M
C	1	F
C	1	M
C	1	F
C	1	M
C	1	F
C	1	M
C	1	F
C	1	M
C	1	F
C	1	M
C	1	F
C	1	M
C	1	F
C	1	M
C	1	F
C	1	M
C	1	F
C	1	M
C	1	F

[ryan_mayu]

@claireberry 

you just need to paste and update the data in the PQ, then after refresh ,you will get the new visual

[claireberry]

This picture is generated using the sample data you used. I just covered the bar with a card so you can see what I ultimately want to achieve. The point is not letting the viewer see that "a" has 5 counts anywhere in the chart. Thank you. 

[ryan_mayu · Accepted solution]

@claireberry 

pls see the attachment below

[claireberry]

Sorry, it didn't completely work for me. I get the above error message when I put measure2 in the Detail -> Data slot. So It couldn't show the "S"

[claireberry]

Yes, this is exactly what I want. Can you let me know what the settings are to achieve that? Mainly, how do you get the "S" to appear? Thank you

[ryan_mayu]

@claireberry 

I 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]

Hi 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

[ryan_mayu]

@claireberry 

pls see the attchment below. you can try to change sum to count

[claireberry]

Thanks for the pbix. Is it possible to let the bar on the right not show the count( no bar at all), just "S"?

[ryan_mayu]

could you pls provde some sample data and expected output? you can draw the chart in excel for a reference.