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 All,
Can someone help me achieve the below results. I have a table with Hosts and their associated IP addresses.
I am looking to achieve the outputs, any ideas please?
Thanks,
Pinky
Solved! Go to Solution.
Hi @Pinky0404,
Take "Output 1" as an example, please create a calculated table as below.
Hosts_1 = SUMMARIZE ( Hosts, Hosts[Hosts], "IP", CONCATENATEX ( Hosts, Hosts[IP], " " ) )
Then, use a table visual to display above data. Turn on the "Word wrap" option and reduce the width of [IP] column.
Best regards,
Yuliana Gu
Hi @Pinky0404,
Take "Output 1" as an example, please create a calculated table as below.
Hosts_1 = SUMMARIZE ( Hosts, Hosts[Hosts], "IP", CONCATENATEX ( Hosts, Hosts[IP], " " ) )
Then, use a table visual to display above data. Turn on the "Word wrap" option and reduce the width of [IP] column.
Best regards,
Yuliana Gu
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |