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.
So I am trying to show average handle time per day with bars and the average of the month with a line. So I wrote a dax fuction but when I want to see the day by day it ended being the quantity of the bars which makes senses so I am stuck. I also do not want to use all since it will not work with any filter if do so.
So for the bar ir drag the column Select average but for the líne I am not sure what fax function i should use so i get the average of the month. I dont want yo use "ALL" since it would not work with Any filter
Solved! Go to Solution.
Hi @Anonymous
Try the below measure
Calculate(AVERAGE(Base[duracion_minuto]), allexcept(Base,FORMAT(Base[date],"YYYY-MM")))
or
Post the sample data
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi @Anonymous
Use the line and clustered column chart and put handle time in the line values section select average as shown below.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@pranit828 i am usi g average gor the bars so i can ser the daily average but u Wanna compare the daily average with the monthly average
Hi @Anonymous
Try the below measure
Calculate(AVERAGE(Base[duracion_minuto]), allexcept(Base,FORMAT(Base[date],"YYYY-MM")))
or
Post the sample data
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@pranit828 I had to check allexcept and I used on my calendar table and it worked! thanks!!
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 |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
105 | |
104 | |
89 | |
65 |