Forum Discussion

dataexplorer123's avatar
dataexplorer123
Frequent Visitor
2 years ago

Query run on Power Automate brings back null for the Selected Value

I have added a new measure, Selected Zone (Selected Zone = SELECTEDVALUE('Table'[Zone])) and Selected Date (Selected Date = SELECTEDVALUE('Table'[Date])). This is the value selected from the slicer ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi dataexplorer123 ,


Does the data in the Power Automate Flow visual contain only the /Selected Zone/ and /Selected Date/ measures?
Have other fields been added?

How are data fields in the Power Automate Flow visual affected by external filtering?

 

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dataexplorer123's avatar
dataexplorer123
Frequent Visitor
2 years ago

Not added other fields, only selected zone and selected date

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi dataexplorer123 ，

    The SELECTEDVALUE function will only return a single value.
    In my testing, Power Automate Flow will only return the single date/country selected in the slicer, not all of them.

     

    How is your Power Automate Flow designed?

    Can you provide some sample data? We can better understand the problem and help you.
    How to provide sample data in the Power BI Forum - Microsoft Fabric Community
    Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

    Best Regards,
    Dengliang Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.