Forum Discussion

Ben_Bocking4's avatar
Ben_Bocking4
Regular Visitor
2 years ago

Column Chart Fields

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?

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Ben_Bocking4
      Regular Visitor
      2 years ago

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

    • Ben_Bocking4's avatar
      Ben_Bocking4
      Regular Visitor
      2 years ago

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

      • SamWiseOwl's avatar
        SamWiseOwl
        Super User
        2 years ago

        Hi Ben_Bocking4  have you tried Anonymous 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.