Hello,
I'm still a noob when it comes to Power Bi and at the moment i'm just playing around with it and I'm strugelling to work out how I would display an average depending on the duration chosen using a slicer.
For example I have a line graph showing the number of users that visited a website per day and I have a slicer which I can use to change the period of time which i can see that data for i.e. one week, one month etc. Next to those graphs I have card inserted currently showing the total number of users over the period selected.
I was wondering how I can how the average number of users over the chosen period rather than the total number?
Many thanks,
Kamil
Hi , @CMMkamil
In card visual ,you only need to change the aggregation type of the field 'Users' from ‘sum’ to ‘Average’.
In line chart visual, you can create a measure as below:
Measure = CALCULATE(AVERAGE('Table'[Users]),ALLSELECTED())
Best Regards,
Community Support Team _ Eason
Hi , @CMMkamil
In card visual ,you only need to change the aggregation type of the field 'Users' from ‘sum’ to ‘Average’.
In line chart visual, you can create a measure as below:
Measure = CALCULATE(AVERAGE('Table'[Users]),ALLSELECTED())
Best Regards,
Community Support Team _ Eason
@CMMkamil Exactly what @lbendlin said. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Power BI Monthly Update - June 2024
Check out the June 2024 Power BI update to learn about new features.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
