Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
48 | |
28 | |
21 | |
19 | |
19 |
User | Count |
---|---|
51 | |
47 | |
25 | |
23 | |
20 |