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

问题描述

我是使用BI的新手，我需要创建一个报告，该报告将根据销售额显示前N个客户的数据。一旦我确定了前N个客户，我就需要其他图表/表格/图表来显示这N个客户的数据。因此，最终我需要一个切片器，该切片器将根据销售额向我显示前N名客户。

我经历了各种报道，他们动态地找到了前N名（断开连接的表），然后可以使用客户名称作为度量。当我将此最高客户度量与其他数据结合在一起时，与前N位客户匹配的行显示topN度量，其余的行显示为空白。

这很好，但是无法解决我的要求。我需要动态地找到前N名客户，然后仅对这些客户进行报告，并对它们进行切片，以便我可以查看特定客户的数据

一些google链接建议这在电源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:

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