I have problem with understand how works Matrix and "Show data point as a table":
The first - I have Table like this:
and I used in Matrix - in row give Name, in Values - Value1, Value2 and Value3. Matrix looks great,
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.
Go to 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.
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.
View solution in original post
How simple it is, as you have already shown, I used SQL and the union function.
Thank you very much.
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.