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
I am trying to display the lookup table values in to a Dashboard.
My table structure is
I want to display the column as highlighted in yellow
Hope someone can help me with this
Thanks
Divya
i found an alternate way for acheiving this
@DivyaNair2022 , You need to duplicate the column in the first table and split it by delimiters (The copied column) , and join it with table 2 with the splitted column
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Then you can display this measure
concatenated(Table1, related(Table2[Name]) )
Thanks @amitchandak for helping me with this.
When we split the column we are actually giving the number of columns to 7 or whatever it is but in my case we don't know how many services the users are going to select so there is no specific number of columns that we can give.
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |