Forum Discussion
Line and Clustered Column Chart
Hello. I want to display sales data over time by item in the clustered column chart and then show total sales for each column with the line chart. For the line chart I don't want it to change as slicers or filters are selected on the report. I have also looked at the possibility of histograms or bullet charts but can't seem to get what I am after.
See this chart. It is the full chart with no filters or slicers. Ideally, I would prefer it to have a data point for each column instead of each x-axis variable but can live with what it is for now. What I want is when the user selects a slicer variable, say customer, the columns change but the line does not so that it still shows total sales regardless of customer.
This is what it does now if a customer is selected.
I am open to all suggestions or other ways to visualize sales by variable compared to total sales.
Thanks!
You could try splitting the data in the line chart to a new table, and create the relationship between the new table and the date table, and put the data from the new table into the chart.
1 Reply
- darentengmfsPost Prodigy
You could try splitting the data in the line chart to a new table, and create the relationship between the new table and the date table, and put the data from the new table into the chart.