Show table data when I click on single bar

[Anonymous]

Hi,

I have the below data set. I need to create a line and clustered column chart for deviation 1 and deviation 2 column. When I click on specific bar, It will show the data as table below the chart or in front of the bar. How can I do that?

Material   deviation 1    deviation 2   value 1    value 2    value 3

A	0.45	0.99	4	3	4
B	0.78	-0.67	5	9	6
C	-0.89	0.33		6	7
D	0.56		6		1
E	-0.22	0.44	1	1	2
F		-0.55	8	5

   

 

Regards, 

Ekram

[Anonymous]

Thanks. It worked

[amitchandak · Accepted solution]

@Anonymous , You ca create a measure that can check if material is filtered

calculate(isfiltered(Table[Material]), Allselected())

or

calculate(int(isfiltered(Table[Material])), Allselected())

Check this is true to 1 in the visual level filter of table

making it invisible it some more workaround to have transparent color $FFFFFF00 , but not everything can be transparent