Forum Discussion

ganeshharan81's avatar
ganeshharan81
Frequent Visitor
6 years ago

Hide show columns dynamically in TABLE

I have two grids,Clicking on one i make the second one visible .The 1st grid is a summary grid and the second one is detail grid.

 

Based on certain conditions i need to make the detail grid show columns dynamically.

 

Clicking on summary grid on top i need the detail to show 4 columns in a certain scenario and 6 columns in another scenerio.

 

Is this possible without using buttons or bookmark logic,just using dax and other features of power bi?

6 Replies

  • Not really, apart from BLANK()ing out the extra two columns via a measure, or using measures as columns.

    • ganeshharan81's avatar
      ganeshharan81
      Frequent Visitor

      can the headers also be made hidden dynamically using measures along with values,if yes ,can you provide some examples.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User

        no, all you can do is print the headers as white text on white background (via conditional formatting). You can't make them disappear.