Error handling for URL filtering

[jess_v]

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_ID	COURSE_NAME
1	Math
2	English
3	Chemistry

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!

[v-eachen-msft · Accepted solution]

Hi @jess_v ,

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.