Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
  • amitchandak's avatar
    4 years ago

    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