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,
Im struggling with this one.. I have a table of data that has part number, store, quantity sold, and a few other columns.
I created a column chart that has the quantity sold with date on the x axis (the date includes just month and year). I want to add a line on this plot (so have a line and clustered column chart) that shows the annual average of quantities. When I add a line for average quantity to this chart, it filters it by month also (because the x axis has month and year). I want the yearly average line for each year on the chart. I also want to be able to filter by part number and store and have the annual average line change with the data. How do I put an annual average line on a chart and ignore the filter caused by the month part of the X axis?
Thanks for your help
Solved! Go to Solution.
You may add the measure below.
Measure =
CALCULATE (
AVERAGE ( 'Table'[quantity] ),
ALLSELECTED ( 'Table'[Date].[Month], 'Table'[Date].[MonthNo] )
)
You may add the measure below.
Measure =
CALCULATE (
AVERAGE ( 'Table'[quantity] ),
ALLSELECTED ( 'Table'[Date].[Month], 'Table'[Date].[MonthNo] )
)
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 |
---|---|
113 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |