Understand Matrix and "Show data point as a table"

[Lukas_317]

HI,

I have problem with understand how works Matrix and "Show data point as a table":

The first - I have Table like this:

Name	Value1	Value2	Value3
Name1	1		1
Name2		1	1
Name3		1	1
Name1	1	1
Name3			1
Name2	1	1	1
Name3			1

and I used in Matrix - in row give Name, in Values - Value1, Value2 and Value3. Matrix looks great,

	Value1	Value2	Value3
Name1	2		1
Name2	1	2	2
Name3		1	3

But, when I used "Show data point as a table" , I get all data, not only this who I chose.

example. I choes PPM on the matrix, 3 and "Show data point as a table" i have all data, not only 3 posytions.

Whay?

[v-chenwuz-msft · Accepted solution]

Hi @Lukas_317 ,

The function "Show data point as a table" is used to show the underlying data of this matrix table visual. So the data is from the orginal table. Please refer this articel.

Visual table and records in Power BI visuals - Power BI | Microsoft Docs

If you want show data point table for only 3 posytions, you should unpivot the orgianl table firstly.

Then, in rows give Name, in columns give Attribute and values give Values.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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

[Lukas_317]

HI,

How simple it is, as you have already shown, I used SQL and the union function.

Thank you very much.