Forum Discussion
Best Visual for Drilldown in Matrix, Table or Heat Chart
Hi Anonymous
Drilldown works on many different types of visuals. You could use a matrix or a column chart or maybe a treemap.
Why not try a bunch of different viz types and see which represents your data best?
- Michele
Yup matrix seems like the best choice 🙂 thanks a lot for the solution.
I had a question relating to the automatic sorting (higher number on the bottom left). Is there a way I can do this? I tried the ellipsis -> sort by. But this only rearranges rows but not columns (higher values on the bottom). How can I move these to values to bottom left? (prefer if I can avoid the rankx function)
E.g. Automatically Move columns 3 and 6 to rows 1 and 2, even when I drill-down into subcategory/subsubcatagory.
Sort each row - row 2 highest value is 285 but it is not at the bottom.
Hi Anonymous ,
As far as i know you should be able to sort the martix by column header but not by the coulumn value.
Best Regards,
Jay