Forum Discussion
Remove zero values from graphs
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...
Hi Anonymous
You may use the 'Edit interactions' and choose the 'filter' icon to achive that. For example:
Regards,
Cherie
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
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