power bi翻转卡片图_将卡片视觉效果提升到Power Bi的新水平

power bi翻转卡片图

I like Power BI, because it offers a whole range of visualizations and out-of-the-box solutions to transform almost every business request into a shiny looking report. Don’t get me wrong, Power BI is much more than a data visualization tool — it can be used in many scenarios as a comprehensive ETL solution.

我喜欢Power BI，因为它提供了广泛的可视化效果和开箱即用的解决方案，可以将几乎每个业务请求转换为具有光泽的报表。 别误会，Power BI不仅仅是数据可视化工具-它可以在许多情况下用作全面的ETL解决方案。

However, Power BI certainly has some limitations when it comes to specific user requests. In those situations, some workarounds and tweakings are necessary in order to achieve desired functionalities.

但是，对于特定的用户请求，Power BI当然具有一些限制。 在那些情况下，为了实现所需的功能，必须采取一些变通方法和调整。

扩展/折叠功能 (Expand/Collapse Functionality)

One of them is Expand/Collapse functionality in visuals other than Matrix. Even in Matrix visual, it was not possible to use the “+” sign for expanding until November 2019 update.

其中之一是Matrix中视觉效果中的扩展/折叠功能。 即使在Matrix visual中，也无法使用“ +”号进行扩展，直到2019年11月更新。

For us coming from the SSRS world, this was so strange and unexpected. Ok, matrices are covered now, but what if we want to apply this same functionality to other visuals, for example, Card visual.

对于来自SSRS世界的我们来说，这是如此奇怪和意外。 好的，矩阵现在已经介绍了，但是如果我们想将此相同的功能应用于其他视觉效果，例如Card视觉效果，该怎么办。

Stay tuned, I’ll show you a workaround, so you can achieve that. As usual, I will use the Contoso sample database for demo purposes.

请继续关注，我将向您显示一个解决方法，以便您可以实现。 和往常一样，我将使用Contoso示例数据库进行演示。

情境 (Scenario)

Let’s say I have a report page showing a stacked column chart in the middle and two card visuals in the upper right corner, showing Sales Quantity and Sales Amount:

假设我有一个报告页面，该页面在中间显示一个堆积的柱形图，在右上角显示两个卡片视觉效果，显示“销售数量”和“销售金额”：