Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 graphs its showing all categories with zeros and with those that have a value. Capture.jpg
Need Help

3 Replies

  • sturlaws's avatar
    sturlaws
    Resident Rockstar
    7 years ago
    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's avatar
    sturlaws
    Resident Rockstar
    7 years ago
    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