Matrix/Table Visual with measures only

[Anonymous]

Hi All,

I want to build below table/matrix visual, they are currently in excel.

Each of the values are measures, there is not any column pulled from the table. I want to create below view in power bi, also this should respect the slicers applied on the page. I pulled all of them in cards individually and they are working with respect to slicer selection but I need the same in table format.

[Anonymous]

Sorry it won't work.

there is not any table values to be pulled in column field of matrix. Every value you see in the screenshot is coming from measure. Cat1, Cat2 these are measures.

[Prateek97]

Hi @Anonymous ,

If Cat1, Cat2, Cat3, All are measures, Then what are the values in the rows. That must be a column coming from aany table

[Anonymous]

There was not any column, I created one table with Cat1, Cat2 etc. I will use selectedvalue to show data.

[Prateek97]

Hi @Anonymous ,

Similarly, you can create another table which will have all the combinations for the Category Column and Row Column. Something like this:

Row Values	Column Values
#Users	Cat1
#Users	Cat2
#Users	Cat3
#Users	All
KPI1	Cat1
KPI1	Cat2
KPI1	Cat3

And then you can use SELECTEDVALUES() 2 times, to pick the row and column context and then put the required measure with the appropriate filters in front of it.

[Prateek97]

Hi @Anonymous ,

You can try switching on the below option - "Switch Values to Rows", which gives the name of the values/measures in the rows, while you can have the category in your columns.

Please mark this as a solution, if it works.

Thank you!