How to configure a Chart item in VC model

[Former Member]

Hi

I am having problem in configuring a chart in VC model.

In my VC model my query output or chart input is Cal Month/Year (Last 12 Months) and revenue. So there will always be 12 rows in output

My requirement is to draw a Column chart for the above query output so that in X-Axis Cal Month/Year

I made the following setting/config for chart item

Chart Type: Column

Data Series: Stacked

Category Axis: Cal_year_month_ext_key

Value Axis: Blank (Default Settings)

Data Series: @revenue

When I compiled, Deployed and executed the modeu2026output is

In X axis all the 12 months are displayed but only the first row value is being displayed in the graph for all the months

Please update me on how to configure a graph

Thanks

[Former Member · Accepted solution]

Hello,

If you have only calmonth in the rows and revenue in your columns of your bi query

pls try using a column chart with "clustered" data series rather than a stacked one

since you have a single data series .

Rgds