Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

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?

Progress Status.PNG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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"

show filter 2.png

 

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

 

show filter 1.png

 

 

Please choose as a solution if it helps. Thx.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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"

show filter 2.png

 

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

 

show filter 1.png

 

 

Please choose as a solution if it helps. Thx.

Anonymous
Not applicable

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

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors