英文:
Creating visual similar to excel table in PowerBi
问题
我有一个包含列如Sr. No，Products，Owner的Excel表格。
数据格式如下图所示：
由于一个序号下有多个产品，在将这些数据导入PowerBi并创建表格可视化时，PowerBi将空序号视为null，不将其与其父序号关联。
我尝试过创建关系和对数据建模，但没有帮助。
期望的结果是，在创建表格可视化后，序号1必须与其下的所有值关联，其他序号也类似。
英文:
I have a excel sheet which has columns such as Sr. No , Products, Owner
The data is in the format like
As one serial number has many Products under it, after importing this data in PowerBi and while creating a table visual, PowerBi takes the empty serial number as null and do not link it with its parent Serial number.
I tried creating relationship and modelling the data, but it did not help.
Expected result is that, after creating a table visual , Serial Number 1 must be linked to all values under it and similar for other Sr. No
答案1
得分: 3
这是关于filldown的内容：
Table.FillDown(Source, {"Sr. no"})
英文:
This is what filldown for:
Table.FillDown(Source,{"Sr. no"})
答案2
得分: 2
在Excel中，您的产品B和M与任何Sr.No.都没有关联。如果尝试使用vlookup、index/match或数据透视表，您会发现它们在Excel中没有关联。在PowerBI中也是一样的情况。如果您想让产品B和M与Sr.No. 1和3关联，您需要像其他用户建议的那样使用"filldown"。这适用于PowerBI和Excel。
您可以使Power BI表格“看起来”像Excel表格，但这仅因为产品按字母顺序排序，与它们与Sr. No.的关联无关。
英文:
In Excel, your Products B and M are not linked to any Sr.No. If you try to do a vlookup, index / match, or pivot table, you will see they are not linked in Excel. In PowerBI it will be the same. If you want Products B and M linked to Sr.No 1 and 3, you need to use filldown like the other user suggested. That applies in both PowerBI and in Excel.
You can get the Power BI table to 'look' like the Excel table, but it is only because the Products are sorted A-Z, it has nothing to do with linking them to Sr. No.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论