Forum Discussion

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 ...

Anonymous

Not applicable

4 years ago

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.

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