Transpose a visualization table

[Anonymous]

Hello to all of you,

I need your help for a problem I have with a visualization table.

I have a table that shows the top 5 movies released in a year (on the whole France or on a particular department).
When I click on a department (or go back to my whole map), the data refreshes.

This table has four columns:
- The title of the movie
- The poster of the movie
- The nationality of the movie
- The number of admissions of the movie

However, I would like to modify this table so that these rows appear as columns.
A transposition of the viewing tables does not seem possible, so I tried to do segment by segment.
I managed to display the image and the number of entries together in one view matrix (and to sort the movies by number of entries) and I would like to add in a second matrix the nationality of the movie.

Unfortunately, if I manage to display the right movies correctly, I can't sort them by entries because if I try to add them, the matrix goes wrong.

In my database, I tried to assign a rank to each film, but I would have to take into account its rank by department and as a whole, and I don't think PB can do a multiple filter (or I haven't figured out how).

I have to admit that I'm out of ideas, so if someone has another possibility to try, I'm interested.

Wishing you a good day.

Raphaël

[Anonymous]

Hi @Anonymous 

You can try to use the custom visual:

Then put the image and related information to the slicer.

Output

Best Regards!

Yolo Zhu

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