Forum Discussion
dynamic table thanx to slicer
Hi all I need your help again. I have 3 customers and 3 years. In each year I have 3 measures (Revenue, Cost, Profit) I would like to use the years in the slicer so when I select one year it wil...
v-caliao-msft
Microsoft Employee
Microsoft EmployeeAnonymous,
As CahabaData said, you'd better reshape your data model, if you have a data model like below.
You could get your expected result easily by using a matrix visual.
If this is not what you want, please provide us moe deatail information, so that we can make further analysis.
Regards,
Charlie Liao
My data set looks similar to this.(I am sorry I cant share it) The above is how I would like to have it displayed in matrix.
The Revenue "year", cost "year", and Profit "year" are all meassures which I would like to have as a drill down option for order type or year. And then I would like to have a slicer where I can just select if I want to see all the measures for lets say Online orders. Does it make sense now ?