Previous Value still showing

[Marcelinno_Juli]

Hi,

I have a “Status” column for entries. I use a Graph to see how many entries I have per status but the legend is showing me a “Status” headings I have deleted. How do I get rid of these?

As per Image I do not have the “Started” option anymore but is still showing up on my legend.

[Suvrutt_Gurjar]

I think the chart will continue to show all enum options, whether a record for an option exists or not.If record count is zero for an option, the option will show but in the chart, the count will be zero.

If you do not wish the [Status] “Started” at all, please delete it from Enum options.

If you wish to display only those statuses where the records are more than zero, please try below

Please create

1. a VC called say [Active Statuses] with an expression something like IFS(IN([Status], UNIQUE(Table Name[Status])), [Status])
2. A slice called say “Active Status” with a filter expression ISNOTBLANK([Active Statuses])
3. Base the chart on this slice “Active Status” and chart column as [Active Statuses]

A similar requirement before

Form shows rows not in slice Questions

I have a table with Leads. One of the columns has the Lead Status. I have a slice that shows only the rows that have certain Lead Statuses. Basically, I am filtering out various statuses such as Closed - Lost. When I View Data in the Slice, it is just as expected. I am using that slice to summarize the number of Leads with the remaining statuses. However, when I use that slice in a form (chart), it shows the statuses that I filtered out. It is not counting the data in those statuses, but it …

[Marcelinno_Juli]

Suvrutt_Gurjar:

ISNOTBLANK([Active Statuses])

Hi,

Thanks for your assistance. I think i might have missed something but please see below pictures.

[Suvrutt_Gurjar]

Thank you. Yes, you are correct, you could have missed some step but from just the picture, it is not clear. Were you able to try all the suggested steps?