Forum Discussion
Matrix/Table Visual with measures only
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 pow...
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.
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
There was not any column, I created one table with Cat1, Cat2 etc. I will use selectedvalue to show data.
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.