cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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

 

Power BI.PNG

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: 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

View solution in original post

7 REPLIES 7
Highlighted
Microsoft
Microsoft

Re: 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

View solution in original post

Highlighted
Super User IV
Super User IV

Re: Best Visual for Drilldown in Matrix, Table or Heat Chart

Highlighted
Anonymous
Not applicable

Re: Best Visual for Drilldown in Matrix, Table or Heat Chart

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) Matrix.PNG

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.

Highlighted
Microsoft
Microsoft

Re: Best Visual for Drilldown in Matrix, Table or Heat Chart

Hi @Anonymous 

To change the sorting 

  1.  Select the visual to make it active
  2. From the More options (...), select "Sort by" and make sure to select your Y axis (that's the one you want to change, right)
  3. Then from More options(...), select Ascending or Descending.

 

HTH

Michele

Highlighted
Microsoft
Microsoft

Re: Best Visual for Drilldown in Matrix, Table or Heat Chart

Oh, wait, you already tried that. OK.  Do this instead...

 

Hover over the column you want to sort and a tiny arrow will appear.  Click the arrow to change the sort order. Sometimes you can simply click on the column header to change the sort too.

 

Ignore my previous reply 😉

 

Michele

Highlighted
Anonymous
Not applicable

Re: Best Visual for Drilldown in Matrix, Table or Heat Chart

Unfortunately, that does not work for columns (no little arrow appears at the edge of the cells). In the entire visualization, the little arrow only appears once - over only the rows subtotal field. It doesn't appear for the subtotal column field. It also does not appear for separate rows (clicking on row leads to drill down) or columns (stay the same, no arrow)

 

Cheers for the quick replies

Rudra

Highlighted
Community Support
Community Support

Re: Best Visual for Drilldown in Matrix, Table or Heat Chart

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors