Column Chart Fields

[Ben_Bocking4]

I have created a column chart visual which displays how many items are at each operation. Along the X-axis all the operations are listed and then the quantity is listed on the y axis. I have a number of different slicers on the page which drill down the visual to show the quantity of items at each operation for specific projects etc. At the minute when i apply the visual the column chart filters to only display operations that have more than one items at that stage however i would like it to display all of the operations even if there are no items at that operation.

Could someone suggest how i may achieve this?

[andrezmar]

Hola Ben_Bocking4. Ya que veo que la pregunta no ha sido marcada como satisfatoria. Intentare darte otra opcion de respuesta.

Tengo un grafico de barras que se filtra a partir de una grafico circular.

Sin filtrar por empresa.

Filtrado por empresa.

Si quieres que despues de haber filtrado por empresa, muestre el valor total sin filtro en un color mas claro y el total del filtro aplicado en un color mas oscuro. Debes realizar el siguiente paso.

Ir al menu archivo, luego Opciones y Configuracion y finalmente Opciones. En configuracion de Informes desactivar:

Cambiar Interaccion predeterminada de los objetos visuales de marcado a filtrado cruzado.

Ya el grafico va a cambiar a esto:

Si está satisfecho con esta respuesta, márquela como solución para que otros la encuentren.

[Ben_Bocking4]

Hi @andrezmar. Thanks for the suggestion but I already have these settings applied and the visuals still remove all other columns when I use the slicer. 

[SamWiseOwl]

Hi @Ben_Bocking4 

Click on the X-axis column (RegionName in this image) and choose Show items with no data

[Ben_Bocking4]

Hi @SamWiseOwl. I have 'Show Items with No Data' ticked however that works until I apply any form of slicers to the visual.

[SamWiseOwl]

Hi @Ben_Bocking4  have you tried @andrezmar suggestion of changing from using cross highlighting to cross filtering?

I'm not 100% sure what the issue is but one way of solving it would be a measure.

Show values with 0 =
If( IsBlank( [Your Calculation], 0, [Your calculation])
So for example:
Show values with 0 =
If( IsBlank( Sum(Sales[Quantity])), 0, Sum(Sales[Quantity]))

This will force the rows to show a 0 and prevent them from hiding.

[Ben_Bocking4]

Hi @SamWiseOwl. I have tried @andrezmar suggestion however that hasnt seem to resolve the problem. The measure also doesn't seem to work with the data and causes some other issues. The problem itself is that when i apply a slicer to the page it filters visuals to only show columns that have data whereas I still want to see the columns that have no data. I have tried your original suggestion of showing items with no data however that only works until a slicer is applied.

[SamWiseOwl]

Can you provide a sample of the problem?

Slicers always want to apply a filter to the visual. As suggested above using cross highlighting on something like a tree map will highlight the matching data.

[Ben_Bocking4]

Unfortunantely not as the data is sensitive. I have done a lot of researching online about this and I think it's as you say a slicer will always filter the visual and there isn't a simple way around this.