Forum Discussion

Maheshmg's avatar
Maheshmg
Frequent Visitor
3 years ago

How to remove blank bars from Clustered column chart

Hi All,

I have region in X- Axis of Clustered column chart and Category in Y - Axis and In Legend i have given Color DAX. 

I want to remove blank bars from Chart. I have tried to remove it by using filters but it did work as expected.

Could someone help me on this.

 

Im unable to attach PBIX file, below mentioned rawdata.

 

 

For Legend color DAX  :

 

Color =
IF(AND('Raw data'[Rating]>=0, 'Raw data'[Rating]<=0.5), "Poor",
IF(AND('Raw data'[Rating]>=0.6, 'Raw data'[Rating]<=1.5), "Average",
IF(AND('Raw data'[Rating]>=1.6,'Raw data'[Rating]<=2.5), "Good",
IF(AND('Raw data'[Rating]>=2.6,'Raw data'[Rating]<=3.5), "Very Good",
IF('Raw data'[Rating]>3.5,"Excellent")))))

 

Raw data 

 

Product NameRegionRating
Advantus Push PinsSouth0
6" Cubicle Wall Clock, BlackWest0.2
9-3/4 Diameter Round Wall ClockCentral0.5
Artistic Insta-PlaqueEast1.1
Global Task Chair, BlackCentral3
StaplesEast3.5
Fiskars Softgrip ScissorsSouth4
Staple envelopeWest0
4009 Highlighters by SanfordCentral0.2
Tennsco Lockers, GrayEast0.5
Adtran 1202752G1South1.1
Staple-based wall hangingsCentral2.5
Acco 3-Hole PunchEast3
Advantus SlideClip Paper ClipsSouth3.5
Aastra 57i VoIP phoneWest4
Storex Dura Pro BindersEast0.2
Acco Hanging Data BindersSouth0.5
Staple removerCentral1.5
Akro-Mils 12-Gallon ToteEast2.5
Tuf-Vin BindersSouth3
Staple holderWest3.5
Bevis Steel Folding ChairsCentral4
American PencilSouth0.2
Coloredge Poster FrameWest0.5
Letter Size CartCentral1.1
Aluminum Document FrameEast1.5
50 Colored Long PencilsWest3
3M Office Air CleanerCentral3.5
Square Credit Card ReaderSouth0
Colored EnvelopesWest0.2
Advantus Rolling Storage BoxCentral0.5
Tennsco Single-Tier LockersEast1.1
Advantus T-Pin Paper ClipsCentral3
Acme Value Line ScissorsEast3.5
Acme Stainless Steel Office SnipsSouth4
Angle-D Ring BindersWest0
Tennsco Regal Shelving UnitsCentral0.2
First Data FD10 PIN PadEast0.5
Airmail EnvelopesSouth1.1
GBC Linen Binding CoversCentral2.5
Acme Softgrip ScissorsEast3
GBC Durable Plastic CoversSouth3.5
3-ring staple packWest4
GBC Instant Report KitCentral0
Advantus Plastic Paper ClipsEast0.2
Acme Box Cutter ScissorsSouth0.5
Staple magnetCentral1.5
Binding Machine SuppliesEast2.5
Things To Do Today PadSouth3
Gear Head AU3700S HeadsetWest3.5
Zipper Ring Binder PocketsCentral4
UniKeep View Case BindersSouth0.2
Staples in misc. colorsWest0.5
GBC Plastic Binding CombsCentral1.1
Aluminum Screw PostsEast1.5
Stockwell Gold Paper ClipsWest3
Assorted Color Push PinsCentral3.5
3M Organizer StripsSouth0
Stockwell Push PinsWest0.2
Staple-on labelsCentral0.5
Toshiba IPT2010-SD IP TelephoneEast1.1
Ultra Door Push PlateCentral3
24-Hour Round Wall ClockEast3.5
Tennsco Double-Tier LockersSouth4
Geemarc AmpliPOWER60West0
Colorific Watercolor PencilsCentral0.2
BIC Liqua Brite LinerEast0.5
GBC Binding coversSouth1.1
Global Super Steno ChairCentral2.5
X-Rack File for Hanging FoldersEast3
12 Colored Short PencilsSouth3.5
Commercial WindTunnelWest4
V7 USB Numeric KeypadCentral0
Binder Clips by OICEast0.2
Colored Push PinsSouth0.5
Flat Face Poster FrameCentral1.5
Tennsco Industrial ShelvingEast2.5
Ultra Door Pull HandleSouth3
Binder PostsWest3.5
Tennsco Lockers, SandCentral4
GBC Personal VeloBind StripsEast0.4

 

Regards,

Mahesh

 

Need Help
Show and Tell
Tips and Tricks

4 Replies

    • Maheshmg's avatar
      Maheshmg
      Frequent Visitor
      3 years ago

      Thank you so much for your response. i have already tried Filter Panel. In filter im not getting any blanks unable to remove blank bars. can you pls suggest me any other approach. 

      • AnkitKukreja's avatar
        AnkitKukreja
        Super User
        3 years ago

        Hi Maheshmg 

         

        Can you please remove the PII and share the pbix file? I can have a look at it.

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Maheshmg ,

     

    After testing, this should not work.

    The data behind the visualization in this scenario is a matrix that affects the rest of the data no matter which arrow it is filtered from.

    Please consider submitting this idea.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum