Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
So I have a report that works appropriately I just cant figure out if there is a way to set the size of the image when some of the rows have 2 "managers".
Ideally I actually want the row size to be the size when there are two managers but if I set it that size then the rows where there are two managers becomes twice as big. I just want the images to be the same size down the entire column regardless of how many managers there are.
Any ideas?
Solved! Go to Solution.
I just decided to combine the managers into one row and then set the size of the box to how big i wanted it.
=JOIN(LOOKUPSET(Fields!Name.Value, Fields!Name.Value, Fields!Manager.Value, "DataSet1"), ", ")
I just decided to combine the managers into one row and then set the size of the box to how big i wanted it.
=JOIN(LOOKUPSET(Fields!Name.Value, Fields!Name.Value, Fields!Manager.Value, "DataSet1"), ", ")
@BDolphin isn't each manager has a separate row? It should show an image of each row with the same size, sorry it is not clear what you are trying to achieve.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k Technically yes each manager has a separate row but i have them grouped on FullName since I dont need to see the FullName twice if there are two managers. The pictures correspond to the FullName. It is possible for a person (fullname) to have two managers or have just one. I want the image to not be twice the size if the person has two managers.
I think you need to set the CanGrow property of the text box to False. Please see this link - https://docs.microsoft.com/en-us/sql/reporting-services/report-design/change-row-height-or-column-wi....
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |