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.
We have Data Like
Month || This Year Count || Last Year Count
Jan || 10 || 5
Feb || 15 || 10
Mar || 20 || 15
We need a bar chart with Month on X-axis and Counts(This Year Count,Last Year Count) on the Y axis.
Now,We need to plot a average line on 45/3=15(This Year Count Average) and another line on 30/3=10(Last Year Count Average)
I would appreciate some help to develop this visual.
Solved! Go to Solution.
@Anonymous
please see the attachment below
Proud to be a Super User!
Hi,
Are This Year Count and Last Year Count actual measures that you have written or are they input data columns available in your base data file?
Hi @Ashish_Mathur Thanks for your reply.
We are using the Measures for Last and Current Year.
Thanks.
Hi,
Do these measures work?
Average = averagex(all(calendar[Month name]),[This year count])
Average1 = averagex(all(calendar[Month name]),[Last year count])
Hope this helps.
Thanks @ryan_mayu for your Reply.
We have tried the Measure and it is working fine.but when we select the month with the slicer, the average line is not affected.
The Requirement we got is to change the average line according to the filter selected.
Thanks
you are welcome
Proud to be a Super User!
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 |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |