Multiple Columns together with Multiple Values

[Anonymous]

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?

[Washivale]

Hi Chris,

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

sorry if i misunderstood your requirement.

[Anonymous]

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

Thanks

Chris

[Anonymous · Accepted solution]

@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

[Anonymous]

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

Thanks,

Nathan

[Anonymous]

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