Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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 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/131725#M56182) which didnt really work for me because I need to display all 3 measures when selecting one year. 

 

Thank you 

 

m

Need Help

3 Replies

  • CahabaData's avatar
    CahabaData
    Icon for Memorable Member rankMemorable Member
    9 years ago

    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.

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      9 years ago

      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 ?