Forum Discussion
Multiple Layers
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.