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,...
Hi sw123
Sure, can you create a data sample and include the expected result, its not easy to understand what you trying to achieve without understanding the scenario.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
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?