Two Data Types with one Total according to a Metric Selection

[Anonymous]

Hello Guys,

I'm having a problem to create my dashboard in PBI.

I have a data that countains two columns with type of data e one column with the total.

But I want to create a Dashboard that when I select Type 2 I have the table segmented by Type 2 and if I select Type 1 this same table is segmented by Type 1.

Do you know how can I do that??

Thanks !

[v-danhe-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, you could refer to below steps:

Unpivot Type 1 and Type 2:

Apply it and use matrix to show your result:

You could also download the pbix file to have a view.

Regards,

Daniel He