Need help in creating a filter, a column which has a multi loopup values

[arulmurugavel]

Hi People,

Need help...

I got the data from Dynamics 365 using a power query. I have a column named Regarding which is a multi lookup entity for leads and opportunity. I need a filter 

+ Regarding

    Lead

    Opportunity     (This should be a slicer like visualization in Power BI)

Once I select Lead, the regarding column name should change to lead and should show only lead values,  the same goes for Opportunity.

Please help

[saraMissBI]

Hi @arulmurugavel ,

I see there is a direct application of a slicer in Power BI. Please refer to the following resource:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

if you have any specific questions, I will be glad to help

Best regards,

[arulmurugavel]

Hi @saraMissBI ,

I need to unpivot a calculated column. Is there any way to do it?

[saraMissBI]

Hi @arulmurugavel ,

You can do that in Power Query Editor. You can find it under the Transform tab, in "Any Column" group.

Thanks,