Removing Aggregation when nothing is selected within the Filter

[Appy1]

Hi Everyone 🙂

Hoping you can help.

When no value is selected within a filter(showing as 'all'), i want my 'target' line (red line) to not appear. However when a value is selected i would want the aggregation to take place and the target to be shown.

Is this possible?

Any help is very ,much appreciated.

Many thanks

Appy1

[Appy1]

Thank you! @Alex87 

[Alex87 · Accepted solution]

Hello,

You will need to use an Area chart visual.

X axis: drag Month Column

Y axis : TotalSum = SUM(Table[Value])

Secondary Y axis :  Dynamic Target = IF(ISFILTERED('Table Filter'[FilterName]), "", [TotalSum])

In order to get close to your target visual, you will need also to do the following format changes:

Title off

Legend off

X axis title off

Y axis title off, Range minimum fx to a DAX measure you need to create / Y min = MIN(Sol[Value]) * 0.95

Secondary y axis title off , values color of your background, range minimum fx = Y min (same for Y axis)

Shade area choose Target Line and switch show for this series off

Lines TargetLine, line style Dotted, width 2, color of your choice (red)

Lines TotalSum color of your choice (purple), width 2

It will look like this and the target line will dissapear when the filter is not selected or selected all

If it answers your question, please mark my reply as the solution