topic Re: 2 separate matrices displaying different values from one table in Custom Visuals Development Discussion

2 separate matrices displaying different values from one table

simona0808 — Fri, 18 Mar 2022 15:36:05 GMT

Hi everyone!

I am trying to create 2 matrices that are populated with data from the same table [Navigation]. The problem is I want matrix1 to show the first 5 values from that column and in the next matrix to show the rest of the values. Is it possible for someone to give me some advice on how this should be done?

For example:

Column X

London

Mexico

Viena

Prague

1st matrix -> NY LA LONDON, 2nd matrix -> MEXICO, VIENA, PRAGUE

Re: 2 separate matrices displaying different values from one table

lbendlin — Sun, 20 Mar 2022 19:08:16 GMT

Power BI has no idea what "the first 5 values " means unless you provide some sort criteria, or an index column. Does your source data have one of these?

Re: 2 separate matrices displaying different values from one table

simona0808 — Tue, 22 Mar 2022 19:43:02 GMT

My table has a rowID column

Re: 2 separate matrices displaying different values from one table

lbendlin — Tue, 22 Mar 2022 19:59:48 GMT

Please provide sanitized sample data that fully covers your issue.

Please show the expected outcome based on the sample data you provided.

Re: 2 separate matrices displaying different values from one table

simona0808 — Tue, 22 Mar 2022 20:56:58 GMT

Sent you a private message. I will publish the solution here once I have a result

Re: 2 separate matrices displaying different values from one table

lbendlin — Tue, 22 Mar 2022 23:19:40 GMT

You can selectively disable interaction for individual visuals. That will proctect them from the overall filter context that is coming from the data model. You can apply individual filters.

- put two slicers on your page

- feed them from the same table

- disable interactions for both of them

- apply visual level filters to each slicer visual as needed.

As long as you only need to call URLs that might be sufficient.

Another, less convoluted alternative may be the new bookmark/page navigator functionality, although I don't know if that supports URLs too.

On a personal note: If you need to include dozens of navigation buttons in Power BI then you may want to rethink your UX expectations.

Re: 2 separate matrices displaying different values from one table

simona0808 — Wed, 23 Mar 2022 12:04:03 GMT

Thank you very much for the suggested ideas. I created the slicer with the URL but I think slicers in powerBI doesn't offer the web URL icon.

Re: 2 separate matrices displaying different values from one table

lbendlin — Wed, 23 Mar 2022 12:59:54 GMT

You can abuse table visuals as pseudo slicers . They support the icons.