cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
Microsoft

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.

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

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
Microsoft

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors