2 separate matrices displaying different values from one table

[simona0808]

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          

NY                     

LA                      

London

Mexico

Viena 

Prague

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

[lbendlin]

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?

[simona0808]

My table has a rowID column

[lbendlin]

Please provide sanitized sample data that fully covers your issue.

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

[simona0808]

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

[lbendlin]

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.

[simona0808]

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. 

[lbendlin]

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