I have a list of two columns.
I'm trying this:
- User Filters the SKU
- The sheet detects the parent category and lists out all the SKUs in that category
Example, if a user selects Apple, the sheet will list out:
I've tried this in my Power BI sheet but I'm unable to get this to work.
Looking for some guidance.
Thanks in advance!
Solved! Go to Solution.
Here's one way to do it:
Bet there's another based on virtual relationships. I'll place a link to a file with the other way in a sec... Most likely you don't want to concatenate. You want to display this in a table, in a visual, so the file above shows you how to do it.
Measure = VAR __SKU = SELECTEDVALUE('Table'[SKU]) VAR __Category = MAX('Table'[Category]) VAR __Table = FILTER(ALL('Table'),'Table'[Category] = __Category) RETURN CONCATENATEX(__Table,[SKU],",")
Thank you for taking the time out, Greg.
Can you please guide on structuring the layout?
An output in the matrix table would be ideal. That'll allow me to display KPIs for the rivals
|Item||KPI 1||KPI 2|
Again, thanks heaps!
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
At the monthly call, connect with other leaders and find out how community makes your experience even better.
Click here to read more about the May 2022 updates!