Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, If anyone could help with quite specific case.
I have a report that is linked to a SharePoint list for additional information. The box shows a row specific information when one is selected. Is there a way to have a basic (or chosen) value for the text box when no rows are selected:
It seems that now the "basic" value is just a random row from the list. I created a dummy row at first and it worked well at the beginning but now the "basic" row is seemingly a random row that changes from the list. It is a bit challenging to give a file because of the SharePoint connection. I tried to play with measures to show the oldest row but didn't get is to work. Don't need a specific code but some ideas how to customize the basic value. Sorry about the redactions.
Solved! Go to Solution.
Try using
SELECTEDVALUE('Table Name'[Field Name],"Alternate text to display when a single value isn't selected")
Try using
SELECTEDVALUE('Table Name'[Field Name],"Alternate text to display when a single value isn't selected")
Thanks! This works.
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |