How to disable line chart forecast when no slicer items are selected?

[Anonymous]

Hi all,

Is there a way to disable the line chart's forecast option based on a condition (e.g. no slicer item is selected)?

My Objective:
- Create a line chart with a 3-period forecast for a selected "Category"

Constraints:
- Categories are selected by a separate slicer.
- When no item in the slicer is selected, the rest of the dashboard elements show other information at one level above "Category" (say "Market").
- The value used in the line chart cannot be aggregated at the "Market" level and is purely a "Category"-specific value.

What I've Done:
- I created a dynamic measure for the value that returns blanks if no item is selected on the slicer. This way, the line chart only appears when a slicer item is selected. This works pretty well.

Measure = IF(SELECTEDVALUE('Table'[Category],0)=0,"",SUM('Table'[Value]))

See sample pbix file here: https://drive.google.com/file/d/19rFV0KRQr2EVbVuIlo99I9a4hRRBCMjd/view?usp=sharing

Where I'm Stuck:
- When I added a forecast to the visual, the line chart no longer disappears when I do not select a slicer item. Instead, it keeps the previous line chart from my last selected item and puts a red X on the upper left, which says, "We need more data."
- This behavior is weird to me, because some items have no data points at all, but the line chart still returns a blank chart as intended.

Has anyone done this before?

Thanks,
A

[PaulDBrown · Accepted solution]

@Anonymous

Hi,

try this and see if it works:

Measure = IF(ISFILTERED('Table'[Category]), SUM('Table'[Value]), BLANK())

Regards,

Paul

[Anonymous]

Hi Paul! This works great!

Could you explain why this works while my previous formula doesn't? Is it to using BLANK() over ""? How can I differentiate the two?

Thanks,

A

[PaulDBrown]

@Anonymous

My guess is that when you add the forecast line, it is generating a conflict in the expression included SELECTEDVALUE, which is intended for single values. The expression ISFILTERED returns TRUE  whenever the column is filtered, whether it be with one OR more "selections" in the "Category" slicer.

Check out the FILTER functions in DAX.