How do I allow users to remove a measure on a graph with a checkbox or drop down?

[Anonymous]

I have this graph for my company which shows Actual, Budget and PY Actual for a certain metric. In certain areas of the business, the PY Actual is very helpful. In other areas of the business, the PY data is not accurate and causes the graphs to look wonky. In this example, you cannot really see the detail because of that March number that throws off the whole chart.

Is there a way to create a checkbox or drop down option for a calculated MEASURE so that if the graph looks weird, they can check a box to remove the PY Actual from the graph?

This is the measure for the line in the graph:

Clinical Comp/RPU-PY-ACT = calculate([Clinical Comp/RPU-ACT],DATEADD('Date'[Date],-1,YEAR))

[Anonymous]

Thank you @v-deddai1-msft ! That worked perfectly and your explanation, screenshots, and formulas were appreciated.

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

You can use a slicer to control the line. First create a disassociated table for slicer:

Then create the following measure for line:

Measure = SWITCH(SELECTEDVALUE(Slicer[value]),1, calculate([Clinical Comp/RPU-ACT],DATEADD('Date'[Date],-1,YEAR)),2,BLANK(), calculate([Clinical Comp/RPU-ACT],DATEADD('Date'[Date],-1,YEAR)))

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai