Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Show table data when I click on single bar

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

A0.450.99434
B0.78-0.67596
C-0.890.33 67
D0.56 6 1
E-0.220.44112
F -0.5585 

 

ekra_0-1651742974255.png   

 

 ekra_1-1651743086172.png

 

 

Regards, 

Ekram

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thanks. It worked

amitchandak
Super User
Super User

@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 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors