Forum Discussion
Solved
Get values selected in slicers from Python
I have a couple of slicers in my report that are built from columns in unrelated tables. I want to get the values selected in those two slicers from my Python script and execute a calculation based o...
Add these columns to the values well of your Python visual. They will then be part of the dataframe.
Hi lg01 ,
You can use DAX functions such as SELECTEDVALUE or VALUES to capture selected values. For example:
SelectedValue = SELECTEDVALUE(Table1[Column1]) Values = Values(Table2[Column2]) import pandas as pd import matplotlib.pyplot as plt df = dataset selected_value1 = df['SelectedValue'].iloc selected_value2 = df['Values'].iloc result = selected_value1 + selected_value2 print(result)Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi lg01 ,
You can use DAX functions such as SELECTEDVALUE or VALUES to capture selected values. For example:
SelectedValue = SELECTEDVALUE(Table1[Column1])
Values = Values(Table2[Column2])
import pandas as pd
import matplotlib.pyplot as plt
df = dataset
selected_value1 = df['SelectedValue'].iloc
selected_value2 = df['Values'].iloc
result = selected_value1 + selected_value2
print(result)
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.