Forum Discussion
claireberry
Helper I
Helper IData 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...
pls see the attachment below
ryan_mayu
Super User
Super Userwe 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