Forum Discussion
How to remove Blank Bars from Clustered Column Chart.
Maheshgm- Can you pls, send me a sample dataset or PBIX file, remove all confidential info.
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 |
|