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...
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.