Forum Discussion
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"?
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.
pls see the attachment below
14 Replies
ryan_mayuSuper User
- 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.
- 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
pls see the attachment below
- 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
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)