Forum Discussion

dfarkas's avatar
dfarkas
Regular Visitor
4 years ago

Crosstab visualization with dynamically changing columns

Hello,   I have the following table: Id     Column1    Column2     Column3   .... Column N 0      cat              male            house  1      dog            male            car 2      cat   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi dfarkas ,

 

If you just want the expected output , you could drag the Id field to Values and choose "Count" summarized type like this:

 

 

Or you could use the following formula to create a summarized table:

NewTable = SUMMARIZE('Table','Table'[Column1],'Table'[Column2],"Count",COUNTROWS('Table'))

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • dfarkas's avatar
    dfarkas
    Regular Visitor
    4 years ago

    Hello Eyelyn,

     

    Thank you for your support. This is what I want and I could do this.

    What I'm struggling with is to include a slicer (or slicers) which let's the user choose which columns to include.

    E.g only Column 1, or Column 2 and 3, or all of them. (In my actual data, I have 38 columns and 1 to 3 selections should be possible to the user).

     

    Best,

    Dávid