Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

filtering via a maesure with python visual

dear reader, 

 

I have made a dashboard to show sales and the history of sales to predict the sales in a python visual. 

 

I have a slicer that filters on the last date, but doesnt influence the python visual becouse it needs to show the history and the prediction based on the data. 

 

i have a tabel that shows 

Name | description | sales number | quarter | Year

computer |13 inch | 200 | quarter 2 | 2024

and manny more there are abouth 41 unique descriptions and abouth 7 times with different quarters and years. 

 

what i want to accomplice is a python visual that reacts to the description clicked on in the tabel but doesnt react on the date there fore i made a measure 

 

SelectedProduct = SELECTEDVALUE(history[description], "No selection")
 

does someone have an idea how to accomplish that goal? with out having to manualy choose a description of name with an slicer i want all to be dynamical to make it easy for the product buyers. 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Anonymous 

    Happy to help, you can share the pbix file without sensitive data for testing purposes, this will help your problem faster.

    Best Regards,
    Yang
    Community Support Team