Forum Discussion
Best Visual for Drilldown in Matrix, Table or Heat Chart
Hi
New to Power BI and was wondering if someone could recommend me the visualization for the following problem:
Visualization – Matrix, Table, Heat Chart (example in the image)
X axis - Catagory 1
Y axis - Catagory 2, with subsets
Values - Number of cases (which belong to both Catagory 1 and Catagory 2)
Feature – Conditional Formatting (shades of blue – high/low) and Drilldown using one table
Thanks
7 Replies
- amitchandak
Super User
Anonymous , Matrix seems to be a better option for you
These 4 should help you
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
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.
