Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Show filter even if it is empty

Hello, I'm completely new to Power BI and have hopefully an easy question. I have a Stacked Column Chart (see below). The X-axis shows the progress status for Data Subjects. There are 4 status values: Identified, Planned, In Progress, and Implemented. In this chart none of the Data Subjects are in a Planned status. Is it possible to include the Planned status in the chart as well, although it does not have any Data Subjects with that particular status?

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    hi Anonymous ,

     

    I am not sure about your table structure. Here is the way I did:

     

    Add a subject named it "." with the status "2-planned"

     

    Change the data color to white so it won't be shown in the Legend 

     

     

     

    Please choose as a solution if it helps. Thx.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    hi Anonymous ,

     

    I am not sure about your table structure. Here is the way I did:

     

    Add a subject named it "." with the status "2-planned"

     

    Change the data color to white so it won't be shown in the Legend 

     

     

     

    Please choose as a solution if it helps. Thx.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank you very much!!! That's exactly what I was looking for!!! Greatly appreciated!!!