I have a table that I'd like to transform depending on a slicer choice. The table has the following data:
I want to create a visual that displays the data above with a slicer for the Manager. When no specific manager is selected (so ALL) I want the data to appear as this:
Then when I select a manager in a slicer (let's say I pick Joe) I want to show the following.
I am guessing I have to invoke some type of grouping or splitting function when the slicer changes, but I am not sure and don't know how to do that in Power BI.
Any help would be appreciated!
Go to Solution.
@shaebert - You can create a new Measure:
Managers = CONCATENATEX(VALUES(Table1[Managers]), [Managers],",")
Hope this helps,
@shaebert add following measure
Managers = CONCATENATEX( Table4, FIRSTNONBLANK(Table4[Manager],""), "," )
Put table visual and add columns Activity, Managers (new measure), Campaign and Sales in it and you will get the result.
Proud to be a Datanaut! Appreciate your Kudos Feel free to email me with any of your BI needs.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!