Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Plot a graph using slicer outcomes

I have a slider slicer that changes a value on a card.   I'd like to plot every 10 points of the slider slicer to the card values on a line graph.   For example, when I move the slider slicer to:...
Need Help
  • Stachu's avatar
    Stachu
    7 years ago

    add this measure

    Measure = 
VAR _WhatIf = MAX('Unique'[WhatIf])
RETURN
CALCULATE(DISTINCTCOUNT('1_INSTALLS'[Machine]),'Unique'[WhatIf]>_WhatIf)

    you should actually disable slider interaction with this chart

Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
7 years ago

add this measure

Measure = 
VAR _WhatIf = MAX('Unique'[WhatIf])
RETURN
CALCULATE(DISTINCTCOUNT('1_INSTALLS'[Machine]),'Unique'[WhatIf]>_WhatIf)

you should actually disable slider interaction with this chart

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks Stachu,

     

    I've inverted the graph using the following logic... is this the easiest way?

     

    Measure = 
VAR _WhatIf = MAX('Unique'[WhatIf])
VAR y = VALUE(CALCULATE(DISTINCTCOUNT('1_INSTALLS'[Machine]),All('Unique'[WhatIf])))
RETURN
CALCULATE(y-DISTINCTCOUNT('1_INSTALLS'[Machine]),'Unique'[WhatIf]>_WhatIf)

     
    Also, where can I send the coffee and donuts to?