Forum Discussion
Solved
Bar chart filtering one bar
Hi, I have a bar chart, where one bar is showing order value average for last 12 month. This I have filtered by filtering the visualization with last 12 months. The axis is showing days (1, 2, 3,...
Ok, so this first chart shows the order value this month:
Order value is a measure:
Order value = SalesTable_[Price]*SalesTable_[Amount]
This means that the order value on the 3rd of march has been around 5t.
My second chart shows average order value for last 12 months:
This means that the average order value last 12 months for the 3rd each month is around 10t.
Now I would like to combine this two charts and thinking that I could add this months bars to the 12 months average bar, if I only could do a measure that filters the order value for this month.
Is this more understandable?