Hi, I would like to create a project that contains "Departments" and would really like to display an image icon representing the department on several charts and/or buttons. I would like to do it dynamically and get those images from a table.
I already have a dimention table "Departments" in Excel that has a Department list:
Department_ID, Department_Name
I would like to add a third column called "Department Image" to my Department table that links to an image somehow, which I will then pull into a Power BI Dashbaord (I suppose I cannot paste an image into an Excel file directly, so it should be a URL pointing to an image or a path to a location like a folder somewhere?)
So, I need a table that would have three columns, where Department_Image is going to contain a path to my image:
Department_ID, Department_Name, Department_Image
Can anyone assist? Thanks!
