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
To change the sorting
- Select the visual to make it active
- From the More options (...), select "Sort by" and make sure to select your Y axis (that's the one you want to change, right)
- Then from More options(...), select Ascending or Descending.
HTH
Michele