前 N 个客户名称作为 Power BI 中的切片器 [英] Top N Customer Names as a slicer in power BI

问题描述

我是 Power BI 的新手，我需要创建一个报告，该报告将根据销售额显示前 N 个客户的数据.一旦我确定了前 N 个客户，我需要其他图表/表格/图表来显示这 N 个客户的数据.所以最终我需要一个切片器，它会根据销售额向我显示前 N 个客户.

我浏览了各种帖子，在那里他们可以动态地找到前 N 个(断开连接的表)，然后将客户名称作为衡量标准.当我将此顶级客户度量与其他数据相结合时，与前 N 个客户匹配的行显示 topN 度量，其余显示为空白.

这很好，但这并不能解决我的要求.我需要动态找到前 N 个客户，然后只报告这些客户，并有一个相同的切片器，以便我可以查看特定客户的数据

一些谷歌链接表明这在 power bi 中根本不可能."

如果您点击左侧表格中的一位客户，您右侧的表格将被交叉过滤以仅显示该一位客户的数据:

i am new to power BI, i have a requirement to create a report which will show the data for top N customer based on sales amount. once i have identify the top N customer i need other charts / table / graphs to show the data of these N customer. so eventually i need a slicer that will show me the top N customer based on sales.

i have gone through various post, there they dynamic way of finding the top N (disconnected table) and then customer name as a measure is possible. when i combine this top customer measure with other data, the row that match with the top N customer shows the topN measure and rest is showing blank.

this is good but this does not solve my requirement. i need to find the top N customer dynamically and then report on those only and have a slicer for the same so that i can see the data for a particular customer

some google link suggested that this is not possible at all in power bi yet. "https://community.powerbi.com/t5/Desktop/top-N-slicer/m-p/171256"

please help in fixing the problem

解决方案

Unfortunately, visual level filters for slicers don't work. One possible workaround would be to use a table as a slicer by using the cross-filtering.

Put the customers in a table and use Top N filtering on the customer field using your sales measure as the value to rank by.

Here's an example of top 3 ranking without any customer selected:

If you click on one of the customers in the left table, then your table on the right will be cross-filtered to only show data for that one customer:

这篇关于前 N 个客户名称作为 Power BI 中的切片器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！