Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
You may try CALCULATE to change the context.
Measure =
CALCULATE ( [Order value], 'Table'[Date].[MonthNo] = MONTH ( TODAY () ) )
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?
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.
Ok, so this first chart shows the order value this month:
Order value is a measure:
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |