Combo Chart Data Labels - Align Density so that labels are visible for the same month

[Anonymous]

Hello guys, im a little bit in trouble with a combo and data labels. 

I want to display a line and a column in a combo chart over several months.

The problem im facing is, that im not able to "align" the data labels for both series in a way, that for the same month BOTH values are shown. 

As you see in the pic, the labels are only "aligned" by chance. 

Is there any way to force PowerBi to only show corresponding values, like show values for Jan. 2019 without having to predefine the values but rather force this "sibling behaviour" ?

Thanks in advance 🙂

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

You can use date hierarchy in x-axis and expand it to next level with concatenate labels on:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[lbendlin]

I think you have too many data points. You can try to change the axis type to categorical but that likely won't help either.