Forum Discussion
How to remove Blank Bars from Clustered Column Chart.
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()
)
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.
Maheshgm- Can you pls, send me a sample dataset or PBIX file, remove all confidential info.
Hi Manoj_Nair I try to send file but I'm unable to attach it. How can I attached PBIX file to chat ?
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.
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
