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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Create an extra table with below Power Query. Remember to set the data type to "Whole Number" for [Column1].

 

Then, in data view, add a calculated column in above table.

Column2 =
CALCULATE (
    DISTINCTCOUNT ( '1_INSTALLS'[Machine] ),
    FILTER (
        ALLSELECTED ( 'Unique' ),
        'Unique'[WhatIf] >= EARLIER ( Query1[Column1] )
            && 'Unique'[WhatIf] <= 499
    )
)

 

Best regards,

Yuliana Gu