Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Error handling for URL filtering

Hello,

 

I am working on creating a URL that will pass a query string parameter to the Power BI report.  Is there any way to handle errors for this?

 

For example, If I have a table COURSES 

COURSE_IDCOURSE_NAME
1Math
2English
3Chemistry

 

And the URL is 

 

app.powerbi.com/groups/me/apps/app-id/reports/report-id/ReportSection?filter= COURSES/COURSE_NAME eq 'Physics'

 

is there any way for me to display the text "There are no courses with a course name of 'Physics'" to the user?

 

Thanks for your help!

Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You could create a new slicer and use parameter to select the value in the slicer.

    Then you could use SELECTEDVALUE() function to create a measure.

    Measure =
IF (
    ISFILTERED ( 'Slicer'[Column] ),
    IF (
        SELECTEDVALUE ( 'Slicer'[Column] ) = SELECTEDVALUE ( 'Table'[Column] ),
        SELECTEDVALUE ( 'Table'[Column] ),
        "There are no courses with a course name of '"
            & SELECTEDVALUE ( 'Slicer'[Column] ) & "'"
    )
)

     Here is the result.

     

1 Reply

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    You could create a new slicer and use parameter to select the value in the slicer.

    Then you could use SELECTEDVALUE() function to create a measure.

    Measure =
IF (
    ISFILTERED ( 'Slicer'[Column] ),
    IF (
        SELECTEDVALUE ( 'Slicer'[Column] ) = SELECTEDVALUE ( 'Table'[Column] ),
        SELECTEDVALUE ( 'Table'[Column] ),
        "There are no courses with a course name of '"
            & SELECTEDVALUE ( 'Slicer'[Column] ) & "'"
    )
)

     Here is the result.