Forum Discussion

sw123's avatar
sw123
Icon for Helper III rankHelper III
6 years ago
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,...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    sw123 

     

    You may try CALCULATE to change the context.

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

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
    sw123
    Icon for Helper III rankHelper III
    6 years ago

    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's avatar
      Mariusz
      Icon for Community Champion rankCommunity Champion
      6 years ago

      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's avatar
        sw123
        Icon for Helper III rankHelper III
        6 years ago

        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?