PowerBI-数据透视表下钻功能 [英] PowerBI - Pivot table drill down functionality
问题描述
我是POWERBI的新手，正在使用它来组合多个大文件并为我汇总数据.
I'm new to POWERBI, and am using it to combine multiple large files and summarize data for me.
我正试图摆脱EXCEL，因为与他人共享时文件可能会变得很大.我想使用 ROW LEVEL SECURITY (行级别安全)并向特定用户授予访问权限.
I'm trying to move away from EXCEL since the files can become large when sharing with others. I want to use ROW LEVEL SECURITY and grant access to specific users.
我的主要问题是，POWERBI中是否有PIVOT TABLE向下钻取功能?我无法在菜单中的任何位置找到此功能，并且不确定他们在他们的论坛上看到的内容，2015年12月，他们正在努力"，但此主持人此后没有任何更新.
My main question is, is there a PIVOT TABLE drill down function in POWERBI? I'm unable to find this anywhere in the menus and looking at their forums people are unsure, December 2015 they were "working on it," but there have been no updates from that moderator since.
推荐答案
与Excel相比，Power BI中绝对缺少数据透视表(矩阵)功能.尚无向下钻取或快速浏览"功能. The pivot table (matrix) functionality in Power BI is definitely lacking, compared to Excel. There is no drill-down or "Quick Explore" functionality yet. 如果不是必需的数据透视表，则可以在条形图/列图上进行向下钻取(这也使您能够对同一页面上的其他图表进行交叉过滤).此处的更多信息: https://powerbi.microsoft.com/zh-CN/documentation/powerbi-service-drill-down-in-a-visualization/. If a pivot table isn't essential, you can do drill-downs on bar/column charts (which also gives you the ability to cross-filter other charts on the same page). More information here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-drill-down-in-a-visualization/. 关于是否将在Power BI中增强数据透视表，Amanda Cofsky上个月发布了有关此想法的更新，表明这是Microsoft的头等大事(确实要求提供有关他们应该将精力集中在哪里的投入): https://idea.powerbi.com/forums/265200-power-bi-ideas/suggestions/15844186-pivot-tables-and-breakdown-trees In terms of whether pivot tables will be enhanced in Power BI, Amanda Cofsky posted an update on this idea last month that suggests this is a top priority for Microsoft (and indeed asks for input on where they should focus their efforts): https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15844186-pivot-tables-and-breakdown-trees 这篇关于PowerBI-数据透视表下钻功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
