How to remove Blank Bars from Clustered Column Chart.

[Maheshgm]

Hi All,

I want to remove Blank bars from chart or i want to show Blank at end of chart.

Could someone please help me on this.

Regards,

Mahesh

[Manoj_Nair]

@Maheshgm-

Have a look at this, although it's quite straightforward. I'm not certain if it aligns perfectly with your requirements.

You should inspect the Filters pane and identify the field leading to the appearance of empty bars in your graph. This is usually the field you've assigned to your chart's Axis. You'll want to adjust this filter to exclude blank entries.

OR

Alternatively, as a hypothetical scenario, consider that I've composed a DAX measure which tallies the sum of 'ProductSales' only when 'Region' isn't empty. Consequently, it prevents the blank 'Region' entries from being displayed on the chart.

Product Sales (No Blanks) = 
CALCULATE(
    SUM('Sales'[ProductSales]),
    'Sales'[Region] <> BLANK()
)

[Maheshgm]

Hi @Manoj_Nair Thank you for your response. I tried both the ways but still issue was not resolved. Can you please suggest me any other approach.

[Manoj_Nair]

@Maheshgm- Can you pls, send me a sample dataset or PBIX file, remove all confidential info.

[Maheshgk]

Hi @Manoj_Nair -  I have tried to attach PBIX file Im unable to do that. i have attached sample data set which i used in this visual. can you please check and help me on this.

I want to remov gap in between bars.

Dax  which i used in chart in legend :

Dax =

IF('raw data'[Rating]== BLANK(),

IF(AND('raw data'[Rating]>=0, 'raw data'[Rating]<=0.5),

IF(AND('raw data'[Rating]>=0.6,'raw data'[Rating]<=1.5),

IF(AND('raw data'[Rating]>=1.6,'raw data'[Rating]<=2.5),

IF(AND('raw data'[Rating]>=2.6,'raw data'[Rating]<=3.5),

IF('raw data'[Rating]>3.5))))))

Product Name	Region	Rating
Advantus Push Pins	South	0
6" Cubicle Wall Clock, Black	West	0.2
9-3/4 Diameter Round Wall Clock	Central	0.5
Artistic Insta-Plaque	East	1.1
Global Task Chair, Black	Central	3
Staples	East	3.5
Fiskars Softgrip Scissors	South	4
Staple envelope	West	0
4009 Highlighters by Sanford	Central	0.2
Tennsco Lockers, Gray	East	0.5
Adtran 1202752G1	South	1.1
Acco 3-Hole Punch	East	3
Advantus SlideClip Paper Clips	South	3.5
Aastra 57i VoIP phone	West	4
Storex Dura Pro Binders	East	0.2
Acco Hanging Data Binders	South	0.5
Staple remover	Central	1.5
Akro-Mils 12-Gallon Tote	East	2.5
Tuf-Vin Binders	South	3
Staple holder	West	3.5
American Pencil	South	0.2
Coloredge Poster Frame	West	0.5
Letter Size Cart	Central	1.1
Aluminum Document Frame	East	1.5
50 Colored Long Pencils	West	3
3M Office Air Cleaner	Central	3.5
Square Credit Card Reader	South	0
Colored Envelopes	West	0.2
Advantus Rolling Storage Box	Central	0.5
Tennsco Single-Tier Lockers	East	1.1
Advantus T-Pin Paper Clips	Central	3
Acme Value Line Scissors	East	3.5
Acme Stainless Steel Office Snips	South	4
Angle-D Ring Binders	West	0
Tennsco Regal Shelving Units	Central	0.2
First Data FD10 PIN Pad	East	0.5
Airmail Envelopes	South	1.1
Acme Softgrip Scissors	East	3
GBC Durable Plastic Covers	South	3.5
3-ring staple pack	West	4
GBC Instant Report Kit	Central	0
Advantus Plastic Paper Clips	East	0.2
Acme Box Cutter Scissors	South	0.5
Staple magnet	Central	1.5
Binding Machine Supplies	East	2.5
Things To Do Today Pad	South	3
Gear Head AU3700S Headset	West	3.5
UniKeep View Case Binders	South	0.2
Staples in misc. colors	West	0.5
GBC Plastic Binding Combs	Central	1.1
Aluminum Screw Posts	East	1.5
Stockwell Gold Paper Clips	West	3
Assorted Color Push Pins	Central	3.5
3M Organizer Strips	South	0
Stockwell Push Pins	West	0.2
Staple-on labels	Central	0.5
Toshiba IPT2010-SD IP Telephone	East	1.1
Ultra Door Push Plate	Central	3
24-Hour Round Wall Clock	East	3.5
Tennsco Double-Tier Lockers	South	4
Geemarc AmpliPOWER60	West	0
Colorific Watercolor Pencils	Central	0.2
BIC Liqua Brite Liner	East	0.5
GBC Binding covers	South	1.1
X-Rack File for Hanging Folders	East	3
12 Colored Short Pencils	South	3.5
Commercial WindTunnel	West	4
V7 USB Numeric Keypad	Central	0
Binder Clips by OIC	East	0.2
Colored Push Pins	South	0.5
Flat Face Poster Frame	Central	1.5
Tennsco Industrial Shelving	East	2.5
Ultra Door Pull Handle	South	3
Binder Posts	West	3.5
GBC Personal VeloBind Strips	East	0.4
Binder	East
Colored	South
Flat Face	West
Tennsco Industrial	East
Ultra Door Pull	East
Binder	South
GBC Personals	West
BIC Liqua	East

[Maheshgm]

Hi @Manoj_Nair I try to send file but I'm unable to attach it. How can I attached PBIX file to chat ?

[foodd]

Upload the file and source file to a cloud-sharing service like OneDrive, Gdrive, Dropbox, etc.   Set the sharing to anonymous, and paste the link in the original post so that a member may easily recognize it from the text and images.   Thank you.

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).  This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.