Bar chart filtering one bar

[sw123]

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, etc), like the average of order value for every first day of the month and so on. Order value itself is a measure multiplying two columns of a table.

Now I would like to have another bar in the same chart showing the order value for this month. How can I do this?

[Mariusz]

Hi @sw123 

Make sure you use the right visual "clustered column chart" and simply add another measure to the Values Container of that visual as below.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[sw123]

Thank you! I am having problem making the new measure though. Any ideas on how I make a measure to filter another measure with only values for current month?

[Mariusz]

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

[sw123]

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?

[v-chuncz-msft · Accepted solution]

@sw123 

You may try CALCULATE to change the context.

Measure =
CALCULATE ( [Order value], 'Table'[Date].[MonthNo] = MONTH ( TODAY () ) )