Forum Discussion
Blake753
Helper II
6 years agoAdd in average line with filtering
Here's the link where they answered part of the question I am asking: https://community.powerbi.com/t5/Desktop/How-to-calculate-an-average-line-in-the-Line-Chart/td-p/232371 What I am looking f...
- 6 years ago
Hi Blake753 ,
Or try this.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-lionel-msft
Community Support
6 years agoHi Blake753 ,
Please refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Blake753
Helper II
6 years agoThis is an awesome start but the average is changing depending on who is selected in the "CountryRegion" filter. I need that average to remain constant of all entities no matter who is selected to look at. In this case when I select 1 CountryRegion, the "average" is just that number divided by 3.