Hiding blanks in Clustered Column Chart

[DJsummers]

Hi

I would very much appreciate help with an issue I am having displaying my data in a clustered column chart, importing data via excel. The raw data looks like:

and my fields are:

and my graph looks like:

I can live with it as it is but I would much prefer the blank space to not be there, I understand why it's there, because I have 5 values in total it is displaying for each day, even when there are 0 entries. I have tried filtering out blanks but it doesn't make any difference:

Is there something obvious I am missing? Maybe a measure I could use?

Thanks in advance all
Dan

[DJsummers]

Thanks both for the help but the advice from @amitchandak has resolved my issue (liked and subscribed via YouTube also)

Thanks again!

[v-xulin-mstf]

Hi @DJsummers,

1. Make sure the following option un clicked.

2. Make sure axis is categorical not continuous. 

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[amitchandak · Accepted solution]

@DJsummers , with a legend you will have that issue. That more and less gap, I think you are looking for that.

Put both of them on the same axis. Sort on day and value and switch of Concatenate label off. ( Repeat this step, if needed as some time this do not work in this order)

You can do conditional formatting for value using a measure and using field value option.

Refer these two videos, in the first one only check power bi part,and second one in conditional formatting for measure

I have covered the above steps

Tableau Vs Power BI- Chapter 4- Bar/Clustered Bar: https://youtu.be/2P5BBRN853c

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4