Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
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
mihart
Microsoft Employee
Microsoft Employee

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
Anonymous
Not applicable

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.

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.
mihart
Microsoft Employee
Microsoft Employee

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

Anonymous
Not applicable

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

mihart
Microsoft Employee
Microsoft Employee

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

mihart
Microsoft Employee
Microsoft Employee

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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.