Skip to main content
Microsoft Idea

Power BI

New

Plot a visualization based on data of a matrix

Vote (1) Share
John Yip's profile image

John Yip on 06 Dec 2021 03:51:13

I have some data in which the filtering conditions are based on a measure (RANKX).
I managed to do some workarounds to make the filtering happen and present them in a matrix.

However, I cannot plot the data in that matrix using other kind of visualizations, because the filtering measure (RANKX) will calculate wrongly.

I plot the data using SUMMARIZECOLUMNS() but the problem is SUMMARIZECOLUMNS() returns a static table and that the filtering measure (RANKX) is meant to be configurable by users.

Would be appreciated if there is a way to plot visualizations based on data in a matrix. The way I can think of is to allow users to store the matrix in a variable, or allows a dynamic summarized table.