Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
Hi Chris,
Use matrix visual and ensure stepped layout is off in Formatting - Row Headers.
sorry if i misunderstood your requirement.
@Washivale - Thanks for your reply. I tried what you suggested but it didn't have any effect.
Thanks
Chris
@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 - A Table visual should work fine - could you share a screenshot of what's happening, or share your pbix?
Thanks,
Nathan
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |