Forum Discussion
Multiple Layers
Getting started with my first Power BI display. After watching a few tutorials that seem to be more complicated, I am not finding how to add multiple X & Y-axis layers so that I can input my data. Maybe Power BI is not the correct solution for a display of a flat excel sheet.
3 Replies
jharlv04 Just drag and drop multiple columns into a visual's X-Axis to create layers. Not sure what you are trying to achieve exactly, maybe an image of what you are trying to accomplish?
Thanks Greg for the quick response. Working on an old school Risk Assessment done in excel. Thinking there has to be a better way to display the 1-5 results for each category. I made a table for each and pulled them into Power BI. It is lining up them as if they are all of equal value. Not in layers. Below is a snipit of the excel sheet and how Power BI is translating it.
jharlv04 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
