Slicer + Matrix

[rlau]

Hi everyone,

I have a slicer where I would like to filter the values in the columns and rows

However if I click one of the senders, I do not get all the values from the columns

[v-veshwara-msft]

Hi @rlau ,

We’re following up once more regarding your query. If it has been resolved, please mark the helpful reply as the Accepted Solution to assist others facing similar challenges.

If you still need assistance, please let us know.
Thank you.

[v-veshwara-msft]

Hi @rlau ,

Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries. 

Otherwise, feel free to reach out for further assistance.

Thank you.

[Idrissshatila]

Hello @rlau ,

so it seems that when you filter on the sender, the values of the  receiver department include the other values not just the specified ones

[rlau]

So how can I achieve that?

[v-veshwara-msft]

Hi @rlau ,
Thanks for using Fabric Community and sharing the screenshots.

The reason you're not seeing all the columns when selecting a sender is likely because the matrix only shows columns where there is data. The rest are hidden by default.

To fix this:

Turn on “Show items with no data”
In the visualizations pane of matrix visual, click the dropdown next to the row and column fields, and turn on this option. It will make sure all possible rows and columns show up, even if they have no data.

If that doesn’t help, you can try a different method using a separate table that lists all sender and receiver combinations. Then, you can create a measure to show values based on this. This makes sure the matrix always shows all columns and rows.

Let us know if you want help setting this up or if the first step works.

Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Thank you.

[v-veshwara-msft]

Hi @rlau ,

We haven’t heard from you since our last response and wanted to check if the provided solutions met your needs. If they did, please consider accepting the solution to help others benefit. Otherwise, feel free to reach out for further assistance.

Thank you.

[HarishKM · Accepted solution]

@rlau Hey,
I have tried to replicate your scenario, and the data is being filtered as expected.

@rlau I will suggest Kindly validate your amount measure. i am using direct sum of point in usd value.

Thanks
Harish M
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[rlau]

Hello,

For the matrix, I am using the following:

And for the slicer the following:

Hope this helps,

[Idrissshatila]

Hello @rlau,

well we need more info on how many tables you're using and what's the relationship between them so that we can assist you with your case.