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, 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?

  • sw123 

     

    You may try CALCULATE to change the context.

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

     

5 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion

    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

      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

        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