Forum Discussion
Display aggregated variable in a graph only if a certain filter selection is met
OK. Understand!
Some updates:
1. Set relationship between Table 1 vs Table 2:
2. Create new Forcast 2 measure:
N Forecast 2 = if(ISBLANK(SELECTEDVALUE('Table 1'[Filial])),FIRSTNONBLANK('Table 2'[Forecast 2],1),0)3. Add N Forecast 2 to your graph
Hi xzmiche. Thanks for the answer!
I think I did not explain my problem well.
Forecast 1 is a variable that contains one forecast type per filial, like using a model such as ARIMA.
Forecast 2 is a different variable, that contains another forecast type for the whole group (NOT per filial). So, it is an aggregated forecast performed with a different model.
Creating the suggested measure, only aggregates the Forecat 1. That I can do already.
I would like to know if it is possible display two different variables in a graph based in a certain condition. Like, when individual filials are selected in the slicer, then only variable Forecast 1 is displayed.
When "select all" is set in the slicer. Then I would like to see Forecast 1 and Forecast 2.
OK. Understand!
Some updates:
1. Set relationship between Table 1 vs Table 2:
2. Create new Forcast 2 measure:
N Forecast 2 = if(ISBLANK(SELECTEDVALUE('Table 1'[Filial])),FIRSTNONBLANK('Table 2'[Forecast 2],1),0)
3. Add N Forecast 2 to your graph
Thank you very much xzmiche ! That's what I wanted. I really appreciate the help!
If you don't want to see 0 on graph, we may update measure formula with:
N Forecast 2 = if(ISBLANK(SELECTEDVALUE('Table 1'[Filial])),FIRSTNONBLANK('Table 2'[Forecast 2],1),"")