Forum Discussion

Ramkumar_Kashya's avatar
Ramkumar_Kashya
Regular Visitor
3 years ago
Solved

How to suppress error from showing on a Visualization

Hi All,

 

I have geocoded data displaying on a ArcGIS visualization. There is also a table showing the greenhouse gas emissions for different locations on the map. When a record is selected from the table I am displaying a high-res image of the location in a image pro visual.

 

When no records are selected the image pro visualization is showing an error on the screen. Is there a way to suppress the error message from displaying.

 

I tried the solution as per https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/  but this is not working for me. Looking for a possible solution so that the error message is not displayed when the report is first viewed.

 

Best Regards,

 

Ramkumar

  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi ramkumarkashyap ,

     

    Based on your description, I have created a simple sample:

    Please try:

    First create a new picture that you want to display when nothing is selected. Such as a blank picture or something like this:

    Then create a measure for its image url:

    Display Imag = "data:image/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAAfQAAAFFCAMAAAAtnu9oAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAADMUExURQAAAAAAOgAAZgA6OgA6ZgA6kABmtjoAADoAZjo6ADo6Ojo6ZjpmZjpmkDpmtjqQtjqQ22YAAGY6AGY6OmY6ZmZmOmZmZmZmkGaQkGaQtmaQ22a2tma222a2/5A6AJBmOpBmZpCQOpCQZpCQtpC2tpC225C2/5Db25Db/7ZmALZmOraQOraQZraQkLa2kLa2tra227bb27bb/7b//9uQOtuQZtu2Ztu2kNu2ttvbttvb29vb/9v///+2Zv/bkP/btv/b2///tv//2////ySKsWgAAAjuSURBVHja7dt5X1vHFYBhEduQeElx0uKQWiaN3bRyncjGagwYAkHf/zv1crXdZWY0I0h+tfW8f9mIOTpz3rvMxmCKrWOgBKSDdJAO0kE6SAfpIB2kg3SQDtJBOkgH6SAdpJMO0kE6SAfpIB2kg3SQDtJBOkgH6SAdpIN0kE46SAfpIB2kg3SQDtJBOkgH6SAdpIN0kA7SQTrpIB2kg3SQDtJBOkgH6SAdpIN0kA7SQTpIB+mkg3SQDtJBOkgH6SAdpIN0kA7SQTpIB+kgHaSTrgSkg3SQDtJBOkgH6SAdpIN0kA7SQTpIB+kgHaSTDtJBOkgH6SAdpIN0kA7SQTpIB+kgHaSDdJBOOkgH6SAdpIN0kA7SQTpIB+kgHaSDdJAO0kE66SAdpIN0kI7PUvr1yXg8fvdJ9esTTPnPSz5L+u9PB4PB7idVt08w5T8v+aX0q/GSt2cfSd8K6ReDFvcOP5K+bdIrvj4nfeukD3b+veXSr0+Ot0D6zsMbvupa30rp12++Wl32n7P04WJU92avtv7gfHulT5rPum2QXl3nrwerH5C+HdKn09HqVid9W6T/dvOE/+I96dsk/frFstekb4v02fN9GE3iavzm4HD8MTDsPa0+eRZcO74a/1x98vZ8mhtr4+ZlKdef/XJw8OrtxyLpia7mzhFCETaQnlnBtdInCenX8+F9VZfD8+5EZ7m683EabtNuFI01vUXzgpQrLo9asevGDfajc7pIV1sl3O8Lnc+KYhFayV90L776vbuf27W7k/7bN42S3D/ujvl7qzs3/LrX+GQ2VkjG6lDYPDvlXtZV7Bzpqa62/TxoebhYBoxHKJSeWcFbPt5bApopXcTW9OaXUMBaNFbgnilonp1ydZt/M9hAeqKrwXFRs6qz9OMRyqRnVjBLev3NwdH7LNv7L8/OzmbPp6WD+pNHL9+dnZ3OHpjLq3zW5tE/qzYnP+51WgRjBUpc0Dw75YXhne/GZ6fjozr2799W65J1/vfqJcrvYxkFuxq+r/s+4xGKpGdWME/6RWyeXn/p4HnzKbdKcPVSuXzayLa+5BdtptPTv75fG6t3xxQ1z055FnpnGfvDIvaagVy0q9E3eDdqPEKJ9MwK5kmf3QChFblR+zdHjYvr4slx+CrvDz7Wxpomxy7rmmenXL83vjgunrJFu9rPsBGlvsTmF0E8Qon0zApmSZ+96EJr790OxoS0rvL+iKEoVnnz3JTrfwbdlszTezd0LMWsYpVIz7axXvrV673oLlv3Wqov3t3YVT7/zcitkBurvHluypPoPVq0OBO9wZq39jxo+EYcxQYkaen5NqLSZ1urDxcDweeBx0397/1udYIdaXwQmLuUxCpvnplyXaOwhSLpk7wwCSWTjaQX2IhKb4/9n4emEOH5fKA6ZydHnVdsbw6ZHau8eWbKiadhgfRWV1PDkfo/w7UR8qVnVzBTeqPEzSTqoIfjBv/pfE21Ivi3h90Z9Xye/eS4l2AyVmeant88M+XIYCG3esGuJp7vk94DKxghX3p+BXOkP3oXWQueDEIsv+byaBBcRpnNjG5mvs/PIysuqdWF4uaZKSfMrpUe62pgPDKPU/dif32EMul5FYxL/8v8DHTiCPQo9TWdlcVmJVYfrWano/yUS5tnppyY4ayRnuhqtHgXrd+KR8iXProD6cP1W32pr1nejw8fV+tb550xxeq6XowWilIua/5HS093NTIuHzWHcYkI/5fSd/511mWVws7yxHyvEvOZ4DLnVKzQG7SgeWbKo00f7+u62pU0XOQ0zIhQJr2ggptKT9Sizub+++Ts4cN8d2O42TmF7OaZKW/6Ts/pam/qfNEcxqUiFA7kik96FEsvGO+Gn52zTaHddd+Z3mLdvaOU4+un6XrmdbXjc9T8rlSE20zZ/hDpiZntqD0hiS18rA7fZa0ZbtY8M+X6o91y6ZldbT3fb1JaBUxF6K8hD6dlexp3LL2x45pecYz/5vJFGo+1bslzbfO8lEMb3jnSs7u6yni3rvBuVoSW9J7X0aCzIldcwWLpre9MVmISm8esyjkabHChZjXPS3meZHCrpET6JL2PPZuqjZoFTkZoJd/dzJntpe6v79pdSg/sS334KbCNOEtu3o+r8+AcJh6rM24vbp6Z8nyB9+tp9s7edF1XY/X7+9OWu1SEVvKzqd1+Z6a3v75rdyl9Ptd43pxAD/t3zfwQz2KXrXFir/kejcbqCChunpnyYiXywXJ999cv36c2eUIPiHZXY9fI473WLZmK0E5+0kz+8kXnBFdmBW8rfX6+6N5hddDn7LQ+ojNsXK47h9WPP3xbdeEf7a3VJ9Vhp2l1NKi3aRuK1b/ryppnprxa33j06uYo1tFeu/KD+9W3vvk+PDYLdzU6lGvfkakIweRvzorV56oet17ymRW8rfTZ2Z4Ww9BK8HDS2U8PHTWMxuo/aoua56bcXw1dupukDkbGu5pYv9vNjBA84LdgtzOyy6vgraWvVhDnPFk8BF+3Nmaj0htPo3isuPSc5tkpV/x3L7xb8CJ1Gjba1fjroFPeeIRu8s3r48F5dzifVcHbS1+tjHX3O5fHcR8dtxaZmsf6uwfyY7Gad0px8/yU6/XdVfTGHx0snwH78VWiflfXLC7kROglv8z95nrvz80zKhiWXsr1yY8HBwff9f6S5vLng4Nnr85DDd5UDZ4F/xAqEusOm6/7vdNffghEvz75ofph7M6JdjWb/AjXN/m9PN6ka3coHZ8upJMO0kE6SAfpIB2kg3SQDtJBOkgH6SAdpIN0kE46SAfpIB2kg3SQDtJBOkgH6SAdpIN0kA7SQTrpIB2kg3SQDtJBOkgH6SAdpIN0kA7SQTpIB+mkg3SQDtJBOkgH6SAdpIN0kA7SQTpIB+kgHaSTDtJBOkgH6SAdpIN0kA7SQTpIB+kgHaSDdJAO0kkH6SAdpIN0kA7SQTpIB+kgHaSDdJAO0kE6SCcdpIN0kA7SQTpIB+kgHaSDdJAO0kE6SAfpIJ10kA7SQTpIB+kgHaSDdJAO0kE6SAfpIB2kg3TSQTo+b/4HWStnW6zlfxUAAAAASUVORK5CYII="

    Apply this measure to the image pro visual:

    Measure = IF(ISFILTERED('Table'[ID]),SELECTEDVALUE('Table'[URL]),[Display Imag])

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Hi Ramkumar_Kashya ,

     

    What do your source data and the error message look like?

    Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

    Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

    Refer to:

    How to provide sample data in the Power BI Forum

    How to Get Your Question Answered Quickly

     

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • ramkumarkashyap's avatar
      ramkumarkashyap
      New Member

      Hi Jianbo,

       

      Please see screenshots below.

       

       

      Here when no record is selected in the table the visual is displaying a message. When there is a record selected then the image is displayed. I need to hide the message when the report/dashboard is first opened and have the different images displayed when records are selected from the table.

       

       

      Best Regards,

       

      Ramkumar

      • v-jianboli-msft's avatar
        v-jianboli-msft
        Icon for Community Support rankCommunity Support

        Hi ramkumarkashyap ,

         

        Based on your description, I have created a simple sample:

        Please try:

        First create a new picture that you want to display when nothing is selected. Such as a blank picture or something like this:

        Then create a measure for its image url:

        Display Imag = "data:image/jpeg;base64,iVBORw0KGgoAAAANSUhEUgAAAfQAAAFFCAMAAAAtnu9oAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAADMUExURQAAAAAAOgAAZgA6OgA6ZgA6kABmtjoAADoAZjo6ADo6Ojo6ZjpmZjpmkDpmtjqQtjqQ22YAAGY6AGY6OmY6ZmZmOmZmZmZmkGaQkGaQtmaQ22a2tma222a2/5A6AJBmOpBmZpCQOpCQZpCQtpC2tpC225C2/5Db25Db/7ZmALZmOraQOraQZraQkLa2kLa2tra227bb27bb/7b//9uQOtuQZtu2Ztu2kNu2ttvbttvb29vb/9v///+2Zv/bkP/btv/b2///tv//2////ySKsWgAAAjuSURBVHja7dt5X1vHFYBhEduQeElx0uKQWiaN3bRyncjGagwYAkHf/zv1crXdZWY0I0h+tfW8f9mIOTpz3rvMxmCKrWOgBKSDdJAO0kE6SAfpIB2kg3SQDtJBOkgH6SAdpJMO0kE6SAfpIB2kg3SQDtJBOkgH6SAdpIN0kE46SAfpIB2kg3SQDtJBOkgH6SAdpIN0kA7SQTrpIB2kg3SQDtJBOkgH6SAdpIN0kA7SQTpIB+mkg3SQDtJBOkgH6SAdpIN0kA7SQTpIB+kgHaSTrgSkg3SQDtJBOkgH6SAdpIN0kA7SQTpIB+kgHaSTDtJBOkgH6SAdpIN0kA7SQTpIB+kgHaSDdJBOOkgH6SAdpIN0kA7SQTpIB+kgHaSDdJAO0kE66SAdpIN0kI7PUvr1yXg8fvdJ9esTTPnPSz5L+u9PB4PB7idVt08w5T8v+aX0q/GSt2cfSd8K6ReDFvcOP5K+bdIrvj4nfeukD3b+veXSr0+Ot0D6zsMbvupa30rp12++Wl32n7P04WJU92avtv7gfHulT5rPum2QXl3nrwerH5C+HdKn09HqVid9W6T/dvOE/+I96dsk/frFstekb4v02fN9GE3iavzm4HD8MTDsPa0+eRZcO74a/1x98vZ8mhtr4+ZlKdef/XJw8OrtxyLpia7mzhFCETaQnlnBtdInCenX8+F9VZfD8+5EZ7m683EabtNuFI01vUXzgpQrLo9asevGDfajc7pIV1sl3O8Lnc+KYhFayV90L776vbuf27W7k/7bN42S3D/ujvl7qzs3/LrX+GQ2VkjG6lDYPDvlXtZV7Bzpqa62/TxoebhYBoxHKJSeWcFbPt5bApopXcTW9OaXUMBaNFbgnilonp1ydZt/M9hAeqKrwXFRs6qz9OMRyqRnVjBLev3NwdH7LNv7L8/OzmbPp6WD+pNHL9+dnZ3OHpjLq3zW5tE/qzYnP+51WgRjBUpc0Dw75YXhne/GZ6fjozr2799W65J1/vfqJcrvYxkFuxq+r/s+4xGKpGdWME/6RWyeXn/p4HnzKbdKcPVSuXzayLa+5BdtptPTv75fG6t3xxQ1z055FnpnGfvDIvaagVy0q9E3eDdqPEKJ9MwK5kmf3QChFblR+zdHjYvr4slx+CrvDz7Wxpomxy7rmmenXL83vjgunrJFu9rPsBGlvsTmF0E8Qon0zApmSZ+96EJr790OxoS0rvL+iKEoVnnz3JTrfwbdlszTezd0LMWsYpVIz7axXvrV673oLlv3Wqov3t3YVT7/zcitkBurvHluypPoPVq0OBO9wZq39jxo+EYcxQYkaen5NqLSZ1urDxcDweeBx0397/1udYIdaXwQmLuUxCpvnplyXaOwhSLpk7wwCSWTjaQX2IhKb4/9n4emEOH5fKA6ZydHnVdsbw6ZHau8eWbKiadhgfRWV1PDkfo/w7UR8qVnVzBTeqPEzSTqoIfjBv/pfE21Ivi3h90Z9Xye/eS4l2AyVmeant88M+XIYCG3esGuJp7vk94DKxghX3p+BXOkP3oXWQueDEIsv+byaBBcRpnNjG5mvs/PIysuqdWF4uaZKSfMrpUe62pgPDKPU/dif32EMul5FYxL/8v8DHTiCPQo9TWdlcVmJVYfrWano/yUS5tnppyY4ayRnuhqtHgXrd+KR8iXProD6cP1W32pr1nejw8fV+tb550xxeq6XowWilIua/5HS093NTIuHzWHcYkI/5fSd/511mWVws7yxHyvEvOZ4DLnVKzQG7SgeWbKo00f7+u62pU0XOQ0zIhQJr2ggptKT9Sizub+++Ts4cN8d2O42TmF7OaZKW/6Ts/pam/qfNEcxqUiFA7kik96FEsvGO+Gn52zTaHddd+Z3mLdvaOU4+un6XrmdbXjc9T8rlSE20zZ/hDpiZntqD0hiS18rA7fZa0ZbtY8M+X6o91y6ZldbT3fb1JaBUxF6K8hD6dlexp3LL2x45pecYz/5vJFGo+1bslzbfO8lEMb3jnSs7u6yni3rvBuVoSW9J7X0aCzIldcwWLpre9MVmISm8esyjkabHChZjXPS3meZHCrpET6JL2PPZuqjZoFTkZoJd/dzJntpe6v79pdSg/sS334KbCNOEtu3o+r8+AcJh6rM24vbp6Z8nyB9+tp9s7edF1XY/X7+9OWu1SEVvKzqd1+Z6a3v75rdyl9Ptd43pxAD/t3zfwQz2KXrXFir/kejcbqCChunpnyYiXywXJ999cv36c2eUIPiHZXY9fI473WLZmK0E5+0kz+8kXnBFdmBW8rfX6+6N5hddDn7LQ+ojNsXK47h9WPP3xbdeEf7a3VJ9Vhp2l1NKi3aRuK1b/ryppnprxa33j06uYo1tFeu/KD+9W3vvk+PDYLdzU6lGvfkakIweRvzorV56oet17ymRW8rfTZ2Z4Ww9BK8HDS2U8PHTWMxuo/aoua56bcXw1dupukDkbGu5pYv9vNjBA84LdgtzOyy6vgraWvVhDnPFk8BF+3Nmaj0htPo3isuPSc5tkpV/x3L7xb8CJ1Gjba1fjroFPeeIRu8s3r48F5dzifVcHbS1+tjHX3O5fHcR8dtxaZmsf6uwfyY7Gad0px8/yU6/XdVfTGHx0snwH78VWiflfXLC7kROglv8z95nrvz80zKhiWXsr1yY8HBwff9f6S5vLng4Nnr85DDd5UDZ4F/xAqEusOm6/7vdNffghEvz75ofph7M6JdjWb/AjXN/m9PN6ka3coHZ8upJMO0kE6SAfpIB2kg3SQDtJBOkgH6SAdpIN0kE46SAfpIB2kg3SQDtJBOkgH6SAdpIN0kA7SQTrpIB2kg3SQDtJBOkgH6SAdpIN0kA7SQTpIB+mkg3SQDtJBOkgH6SAdpIN0kA7SQTpIB+kgHaSTDtJBOkgH6SAdpIN0kA7SQTpIB+kgHaSDdJAO0kkH6SAdpIN0kA7SQTpIB+kgHaSDdJAO0kE6SCcdpIN0kA7SQTpIB+kgHaSDdJAO0kE6SAfpIJ10kA7SQTpIB+kgHaSDdJAO0kE6SAfpIB2kg3TSQTo+b/4HWStnW6zlfxUAAAAASUVORK5CYII="

        Apply this measure to the image pro visual:

        Measure = IF(ISFILTERED('Table'[ID]),SELECTEDVALUE('Table'[URL]),[Display Imag])

        Final output:

        Best Regards,

        Jianbo Li

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.