Combo Chart (line/bar)

[ZoeM]

Hello Community.

I have a line chart that shows the years planned sales data. I would like to add a bar chart, but only one bar showing the total planned for the current month. So given this is July, my chart would show the 12 month line chart and one bar for July showing the total, like the attached.

Any help will be truly appreciated.

[Lisa_P]

Create the chart with all the measures and add in the measure for the current month by applying set analysis to limit it to only the current month

Sum({<Month={$(=Month(Today()))},Year={$(=Year(Today()))}>}GatewaysActual)

This will work out the current month and year and apply that as a filter

[ZoeM]

Hi Lisa,

Thanks for that suggestion. I tried adding the month portion of the set analysis you provided and the expression doe snot like it, not sure if I used variables it recognized.

[Anil_Babu_Samineni]

I have work around, If you can provide sample data set