how to show list of names based on slicer selection By DAX

[snandy2011]

Hi All,

I have an question, is there any way to show list of name by DAX based on slicer.

For example,

I have a slicer with two value. (Customer and Poduct). The scenario is that, when i will click the customer on the slicer, it will show the all list of customer name, again when i will click the product on the slicer,then it will show all list of product name.

The reason behind that is i am going to analysis top customer and product.so, generally, i can create two visualization.One for top customer and other for top product.But, i want to create only one visualization for them.so for that, i have to  return list of all customer and product name dynamically from slicer selection.

Can i achieve above situation by writing DAX? 

Any suggesation is really appreciable.

Thanks,

snandy

[BobBI · Accepted solution]

Hi,

I have achieve this by created a another table with unpivot values.

Main table :

ID | customer | product | Amount

Data set ( unpivot table)

Attribute | ID | value  ( see the screeshot to see values)

I use arttribute field in the slicer and Value filed in the table.

Hope this hellps.

Cheers

Bob

resultMain tablejoin tableunpivot table ( amount removed)

[snandy2011]

@BobBI,

Thank you very much.. i was looking for this solution.. thanks a lot..

snandy

[BobBI]

Great , Have Fun with Power BI 🙂  thums up.

[AkhilAshok]

Have a look at this video. It should help: