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  ...
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.

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity 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.