Remove zero values from graphs

[Anonymous]

Is there a way to remove or move down the zero value options from the graphs when you filtering the page? For example i have one table and two graphs. When i choosing one service from the table in the graphs its showing all categories with zeros and with those that have a value.

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may use the 'Edit interactions' and choose the 'filter' icon to achive that. For example:

Regards,

Cherie

[sturlaws]

The easy solution is to change the interaction between the table and the chart from Highligh to Filter. That will make all the zero values disapear from the chart.

But if you like to keep the highlighting, there is a workaround.
Create a new measure Clients=sum(Table[Clients]), if you don't have it already.
Create another measure AllClients =
IF ( ISFILTERED ( Table[Service categories] ); CALCULATE ( SUM ( Table[Clients] ); ALL ( Table[Service categories] ) ) - [Clients]; BLANK () )
Change the chart to a Stacked bar chart, and add both these measures to the value-field of the chart, with [Clients] above [AllClients]. Change the color of [AllClients] to a light green. If you filter the chart on [Client], the Agencies with zero will move to the bottom. If you in the filter area set [Clients] greater then 0, the agencies with 0 value will disappear from the chart

[sturlaws]

The easy solution is to change the interaction between the table and the chart from Highligh to Filter. That will make all the zero values disapear from the chart.

But if you like to keep the highlighting, there is a workaround.
Create a new measure Clients=sum(Table[Clients]), if you don't have it already.
Create another measure AllClients =
IF ( ISFILTERED ( Table[Service categories] ); CALCULATE ( SUM ( Table[Clients] ); ALL ( Table[Service categories] ) ) - [Clients]; BLANK () )
Change the chart to a Stacked bar chart, and add both these measures to the value-field of the chart, with [Clients] above [AllClients].
Change the color of [AllClients] to a light green. If you filter the chart on [Client], the Agencies with zero will move to the bottom. If you in the filter area set [Clients] greater then 0, the agencies with 0 value will disappear from the chart