Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How can I Create multiple columns selection in Power BI

Hi Everyone,


I want to provide end user the option to select any column, for example we've sales and want to see sales by Country, State or Customer so that user can select any column that we've added from a single selection.

Thanks,

column selection
Multiple columns

15 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , You can do it using bookmarks or Unpivot the columns 

     

    Dynamically change chart axis in Power BI
    bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
    https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
    https://www.youtube.com/watch?v=6jeSIRpjv0M

     

    Unpivot means, you need Country, State or Customer to become rows values, then you can filter them in slicer and a new column can be used as the axis

    https://radacad.com/pivot-and-unpivot-with-power-bi

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for responding,

      I know these options but with these options we will provide all the columns but I want to provide 3 or 4 columns, I want to do something similar to tableau parameter that I can further use in calculation, Please let me know if we can achieve something like that.

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    I don't quite understand what you're asking. Can you illustrate or link to an example that behaves the way you're describing?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi AlexisOlson ,

      Sorry for late reply.
      Here's an sample, suppose we have these three column in the data like this

       I wan to provide user the flexibility to switch between CUSTOMER_LEVEL_1,2,3 from a single slicer like this without unpivoting the data as I've multiple columns and measure in the orignial data and in some charts we're using these column individually.

      Hope that I was able to explain, let me know if these are enough to provide some kind of solution.

       

      • AlexisOlson's avatar
        AlexisOlson
        Icon for Super User rankSuper User
        4 years ago

        You can create a parameter table with the column names that you want to choose between to use as a slicer and then define a switching measure that reads the slicer selection and outputs different results based on different selections.

         

        I can't tell if this resolves your particular use case or not.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

     

    If it not, would you mind telling me a more detailed description of your needs so that I can help you better?

     

    Hope it helps,


    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      No I wasn't able to get the correct answer.

      Let me try to expalin again. In this image I am showing sales data against cutomer. but I want provide an option where user can switch different column as well for example category,country, segment etc.   same way that we select options in slicer

       

      • AlexisOlson's avatar
        AlexisOlson
        Icon for Super User rankSuper User
        4 years ago

        So you want to switch between different dimensions in the left column?