Forum Discussion
Adding Max and Min Growth Lines to Line Chart with Dynamic Measures
Community ChampionShahabh786 Have you looked at the Analytics pane?
Hi Greg_Deckler
Thanks for the suggestion!
Yes, I’ve explored the Analytics pane, but the challenge I encountered is that it provides a straight line for the max and min values. What I’m aiming for is to highlight the specific months or years where these max and min growth values occur with two distinct points, rather than a continuous line.
To achieve this, I believe using a measure would be more flexible. This way, I can dynamically calculate and display the min and max values for the selected metrics, and also apply additional insights if needed in the future. This approach would give me more control over the visualization, allowing the chart to reflect these values accurately in the context of the selected growth metric and measure.
Would appreciate any guidance on how to create such measures or if you have any other suggestions!
Thanks again for your help!
- Greg_Deckler
Shahabh786 Well, in that case you could have the measure return a value for the min/max and blank for everything else and then perhaps turn on a marker for that line series. I didn't download your PBIX file but you could do something like this:
Min Measure = VAR __Measure = [Original Measure] VAR __Table = SUMMARIZE( ALL('Table'), [Year], [Month], "__Value", [Original Measure] ) VAR __Min = MINX( __Table, [__Value] ) VAR __Result = IF( __Measure = __Min, __Measure, BLANK() ) RETURN __Result