Forum Discussion
Produce Average Line in Small Multiples Visual
TomTomTom ok then add this measure for flat line
Measure =
CALCULATE ( [Your Measure], ALLSELECTED ( DateDimensionTable ) )
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Just to say this problem remains unresolved.
If anyone ( parry2k - ?) has some fresh ideas that'd be great.
My thought is that when using small multiples, somehow one measure can change the filter context for other measures. Maybe the solution is to roll-up/group-by the data set in some way with calculated columns before bringing it into the visiaul. Although I think this would then break the connection with the data model, so it'd be quite an ugly fix.
I have a while before I need to implement the constant lines... I'll keep trying ideas for a 'good' solution.