dynamic table thanx to slicer

[Anonymous]

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 will display all 3 measures for that year.

See picture for better understanding

I found a post (https://community.powerbi.com/t5/Desktop/How-to-display-different-measures-using-a-selector/m-p/1317...) which didnt really work for me because I need to display all 3 measures when selecting one year. 

Thank you 

m

[v-caliao-msft]

@Anonymous,

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

[Anonymous]

Hi @v-caliao-msft

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 ?

[CahabaData]

rather than a side-by-side display; can you un-pivot and transform/normalize the date set to stacked years? - - this would then be the more standard approach.