Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Multiple Columns together with Multiple Values

Hi, I am having troubles showing multiple Columns together with mulitple Values. This is a very easy thing to do using pivote tables, but I couldn't figure out how to do this in Power BI with neither a Table nor a Matrix. For example, the closest thing to what I want to create, would be the Matrix, but it only allows me to show 1 column with the 4 values, instead of 4 columns with 4 values. See below the ideal version. How do I show Multiple Columns together with Mulitple Values?

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous , Washivale - Thanks for your help - I think I figured it out. It seems to have been the the Data / Drill function that didn't let show the data. It now works .

    Chris

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous - A Table visual should work fine - could you share a screenshot of what's happening, or share your pbix?

    Thanks,

    Nathan

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

       

       

      Thanks for your reply. Below are both, the CURRENT version and the IDEAL version. No matter how many columns I add, it will only show the first one.

       

      CURRENT:

       

       

       

       

       

       

       

       

      IDEAL:

       


       

       

       

       

       

      I can see in visualizations that the additional columns are there, but they won't show.

       

      Thanks

      Chris

  • Washivale's avatar
    Washivale
    Resolver V
    7 years ago

    Hi Chris,

     

    Use matrix visual and ensure stepped layout is off in Formatting - Row Headers.

     

    sorry if i misunderstood your requirement.

     


    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Washivale  - Thanks for your reply. I tried what you suggested but it didn't have any effect.

      Thanks

      Chris

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Anonymous , Washivale - Thanks for your help - I think I figured it out. It seems to have been the the Data / Drill function that didn't let show the data. It now works .

        Chris