Urgent : Masking the customers based on the selection from slicer

[Gjn]

Hello Everyone,

Apologies,I am new to PowerBI...i have below requirement.

From the below dataset,i need to generate barchart/clusterchart where if i select one customer from the slicer then other customers should be masked on the chart.Kindly note i have in my data almost 20 number of customers...suppose if i select customer 15 then only customer 15 name is visible on the bar chart and remaining all the customer names should be masked but bars should be displayed in the chart.

Kindly let me know if you need more information.

Appreciate your help...!!!

Customer	dept	sales
Customer1	A	10
Customer1	B	20
Customer1	C	30
Customer2	D	20
Customer2	E	10
Customer2	F	10
Customer3	G	20
Customer3	H	35
Customer3	I	10

[Ritaf1983]

Hi @Gjn 
Can you show the desired result?

[Gjn]

The desired output will be as below...
if i select the customer1 from the slicer then i need to populate the original name for customer1 bar and remaining bars should be masked to 1 and 2.
And in the same way if i select customer2 then customer2 should be populated and remaining customers should be masked and so on...

[Jai-Rathinavel · Accepted solution]

Hi @Gjn , I have achieved the similar output by tweaking the dax. Masking the customer names on x axis level is not possible since columns are evaluated during a model refresh and cannot be made dynamic. 

But this file should solve your scenario: Download New PBIX

Outputs:

Did I answer your question ? If yes, please mark my post as a solution

Thanks,

Jai 🙂

[Jai-Rathinavel]

Hi @Gjn ,

I have achieved your requirement in a sample PBIX: Download PBIX

Please apply the same visual settings used in my file to yours. Like turning off x axis labels, tooltips.

Did I answer your question ? If yes, please mark my post as a solution.

Thanks,

Jai 🙂

[Gjn]

Hello Jai,

Thanks for your reply...it is similar result which i am excepting and as of now we are populating customer2 based on the slicer selection and i addition to that i need to populate the masked customers like 1 and 2 for other bars in the chart.