Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Changing dimensions interactively

Below i have created a table which contains Location as Dimension and rest columns as measures. In my master table i have other dimensions also like Industry, Program, Sales Manager, Turnover etc and i want to have a slicer like below(Dummy) where i can select the dimensions and it gets reflected in the table. For example in below snap i have selected Location as my dimension  and all my meaures are getting calculated on location basis but i want if i select any dimension from the slicer the measures should get calculated on the basis of the selected dimensions and selected dimension should come in the first column.

 

This will allow me to have a single chart for all dimensions instead of having one chart for each dimensions.

I hope the above makes sense. Please let me know if you need some more clarification/elaboration on the question.

 

Thanks,

Piyush

Need Help

2 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    8 years ago

    Anonymous,

     

    There is no such a functionally to acheive this currently. To work around this requirement, we can create a dynamic measure based on selection in slicer. For the details, please refer to the link below.
    http://community.powerbi.com/t5/Community-Knowledge-Base/Dynamic-column-based-on-slicer-selection/ta-p/162635

     

    If this is not what you want, I am afraid there is no other approach to acheive this requirement. Thank you for your understanding.

     

    Regards,

    Charlie Liao

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks Caliao for responding but i am not sure if this is what i want. I will try to reframe the question.

       

      Below i have created a table which contains Location as Dimension and rest columns as measures. In my master table i have other dimensions also like Industry, Program, Sales Manager, Turnover etc and i want to have a slicer like below(Dummy) where i can select the dimensions and it gets reflected in the table. For example in below snap i have selected Location as my dimension  and all my meaures are getting calculated on location basis but i want if i select any dimension from the slicer the measures should get calculated on the basis of the selected dimensions and selected dimension should come in the first column.

       

      This will allow me to have a single chart for all dimensions instead of having one chart for each dimensions.

       

      I hope the above makes sense. Please let me know if you need some more clarification/elaboration on the question.

       

      Thanks,

      Piyush