Forum Discussion
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
| 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 , 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
2 Replies
- amitchandak
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