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!
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!
Watch Session 22 Ted's Dev Camp along with past sessions!
Click here to read more about the May 2022 updates!