Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, Please can somebody help me find a visual to suit my requirements.
I have a table of data which has vehicle fleet numbers and the week number in which they are to be serviced:
The requirement is to produce a table/matrix which displays the vehicles fleet number in the week column for which they are due a service:
Is there a visual in BI that will allow me to display the data as shown?
Any assistance appreciated.
Solved! Go to Solution.
You can just use the matrix visual. Put Week Number in for Columns and use this measure in the Values.
Fleet List = CONCATENATEX(VALUES(Table[Fleet Number]), Table[Fleet Number], "
")
Note there is a carriage return in the measure between the quotes. Use Shift+Enter to do that if needed. Replace Table with your actual name of your table.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@msommerf , refer to this video of creating a list. see if this can help
https://www.youtube.com/watch?v=WSnB5y2JXv8
You can just use the matrix visual. Put Week Number in for Columns and use this measure in the Values.
Fleet List = CONCATENATEX(VALUES(Table[Fleet Number]), Table[Fleet Number], "
")
Note there is a carriage return in the measure between the quotes. Use Shift+Enter to do that if needed. Replace Table with your actual name of your table.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |