Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Not able to concatenate labels

Hi,

I'm not able to concatenate labels and display as a combination of Year and Month. Instead Power BI combination chart is summing up values across years and showing month wise in the drilled report. I have data spanning across years 2021 and 2022.

I've selected Concatenate Labels Off and also tried turning it On. Also, for the X axis which is the date axis, i've selected Type as Categorical.

 

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Don't use the auto date/time function. Use your own Calendar table where you can decide how to format the hierarchy elements.