Visualization Help

[kitala11]

Anyone knows if there is any visualization that can create a bar chart with an x-axis like this?

When I try to drag the 2 columns, 1 does not have date so I just want a total column for it, then I drag another column which can be displayed across months like this. 

Target Value    Jan Feb Mar Apr May .... Dec

This is how it looks right now, I only want a the dark blue column as a singular column instead of being repeated for every month

[v-kelly-msft · Accepted solution]

Hi  @kitala11 ,

First create a column as below:

Total = IF('Table'[Date]=MAXX(ALL('Table'),'Table'[Date]),SUM('Table'[Value]),BLANK())

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@kitala11 , In that case, you need add a date in the target table like Year start or year and join that with Date table

You can check this video for date in target table https://www.youtube.com/watch?v=yPQ9UV37LOU