Single Selection on Matrix Visual

[TameshDoobay]

Hi,

I'm currently trying to utlize the Matrix visual alongside a third party PDF Viewer visual (from DS Analytics AB). 

The functionallity is: Use the matrix to select what PDF to view.

This typically works with a slicer or a table, but I want it to work with a matrix. The problem is, when I select an item in the matrix, it selects all of its children in the hierarchy as well. The PDF Viewer only works based on single selection. 

TLDR; How can I get the matrix visual to only select the row that I'm clicking on and not all of it's children.

Thanks,

Tamesh

[Anonymous]

Hi @TameshDoobay ,

First of all, thanks @Sergii24  for the quick reply.

Sorry, so far, to my knowledge, this may not be achieveable.

An alternative solution is to just place the top-level data on the matrix visual, so that you don't get the values of the child layers when you click Select.

You can submit an idea for it at Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[TameshDoobay]

Unfortunately, still no solution. I'm have extreme difficulty. I really want the Matrix to return a single value instead of it's children as well. I like the drop +/- feature, it's great for MultiBOM views.

[Sergii24]

Hi @TameshDoobay, could you elaborate more on what you want to achive? Let's see if there is an alternative 🙂

Matrix levels are aggregating items, now let's say you click on the first level (which means you have selected multiple sub-items). Now you're saying you want to return a "single value". What does it mean? If you have, let's say 5 sub-items selected when you clicked on the first level of hierarchy, which of 5 should be selected? Max/min/first/last etc.? If you select only 1 of them, why do you still want to use matrix? What is a point of having +/- feature if when used, there is just 1 item at a subsequent sub-level?

Make sure to describe your case in details, provide sample data/pbix to test (mask data if it's sensitive) and provide details of desired output (including images).  

[Sergii24]

Hi @TameshDoobay, I believe you can't. Selecting an item and corresponding children items is the whole point of matrix visual. If you want to get to the lowest level of granularity, use table visual.

I hope you'll find this answer useful. Good luck on your project!

[TameshDoobay]

Thanks for your reply @Sergii24 . I understand what you're saying. I'm currently trying to figure out how to take the array of values returned and distinctly return the selected value. Then pass it over to the visual some how.