将 tableau 报表复制到 Power BI [英] replicating the tableau report into power BI

问题描述

我正在尝试将其中一个 tableau 报表复制到 power bi 中.我是 tableau 和 power BI 的新手，所以我只是在网上学习并从事这个项目.因此，我在添加过滤器和分组列方面几乎没有问题.

tableau 中有一个自定义查询用于构建报告.我在 power bi 中使用相同的报告来复制相同的报告.我附上了下面的代码.我已经在 power bi 中加载了查询并可视化了数据.但我想添加与表格报告相同的过滤器.但我不确定如何在 Power BI 中添加这些.问题 1:如何以与 tableau 中使用的相同方式将过滤器添加到 power bi(附截图)问题2:在表格过滤器报告日期"中使用了一个条件(报告日期>=添加日期和报告日期<=删除日期.您能帮我如何在power bi中创建相同类型的过滤器吗?3. 如何像 tableau 一样按 power bi 中的列分组?(附截图)

解决方案

很好，您正在尝试学习 Power BI 和 tableau，这两个非常棒的工具！我不会因为准确回答你的问题而破坏你的学习，但我可以给你一些指导.

1. 尝试使用切片器视觉对象和视觉对象选择下拉菜单.

1. 这在 Power BI 中有点复杂，因为它需要您创建多个对象.首先，您应该为您的参数创建一个值列表.您可以使用创建新表并使用

   其次，您创建一个度量来确定表中的行是否符合您指定的条件.这需要一个度量，因为计算的列不接受可变参数.

   包括=var _selectedDate = SELECTEDVALUE( Parameter[Date] ; MIN ( Parameter[Date] ) )返回总和(投资；如果 (AND(表[添加日期] <= _selectedDate ; 表[dropdate] >= _selectedDate);1;0))

   将度量添加到矩阵的可视过滤器中，并确保它过滤值 1.

   最后，将 Parameter[Date] 字段添加到您的报告页面，并将其设置为问题 1 的答案中提到的视觉样式切片器

   1. 尝试矩阵可视化并确保深入了解视觉效果.将鼠标悬停在它上面并选择分支箭头.

   I am trying to replicate one of the tableau report into power bi. I am new to tableau and power BI so I am just learning from online and working on this project. Hence I have few questions in adding filters and grouping columns.

   there is a custom query used in tableau to build the report. I am using the same report in power bi to replicate the same report. I have attached the code below. I have loaded the query in power bi and visualize the data. but I wanted to add the filters same like the tableau report has. but I am unsure how to add those in power BI. Questions 1 : how do I add the filters to the power bi in a same way it is used in tableau(screenshots attached) questions 2: in tableau filter "report date" is used a condition (report date >=adddate and reportdate<=dropdate. could you please help me how to create the same type of filter in power bi? 3. how do I group by the columns in power bi in the same way as tableau does?(screenshot attached)

   解决方案

   Good you are trying to learn Power BI and tableau, two really great tools! I'm not going spoil your learning by precisely answering your questions, but I can give you some directions.

   1. Try using the slicer visual and in the visual select drop-down.
   2. This one is a bit more complicated in Power BI as it requires you to create multiple objects. First you should create a list of values for your parameter. You can do this using Create New Table and using the CALENDAR() function, it's called a calendar table. Combine it with a MIN() and MAX() function to get the first and last dates in your dataset.

   Parameter = CALENDAR( MIN ( Table[adddate] ) ; MAX ( Table[dropdate] ) )
   

   Secondly, you create a measure which will determine if a row in your table matches the criteria you specified. This needs to be a measure, as calculated columns do not accept variable parameters.

   Included = 
       var _selectedDate = SELECTEDVALUE( Parameter[Date] ; MIN ( Parameter[Date] ) )
   
   RETURN
       SUMX ( 
           Investments ;
           IF ( 
               AND ( Table[adddate] <= _selectedDate ; Table[dropdate] >= _selectedDate )
               ; 1 
               ; 0 
           )
       )
   

   Add the measure to the visual filters of your matrix and make sure it filters for the value 1.

   Finally, add the Parameter[Date] field to your report page and set it to the visual style slicer as mentioned in the answer to question 1

   3. Try the matrix visualization and make sure that you drill down in the visual. Hover your mouse over it and select the branched arrow.

   这篇关于将 tableau 报表复制到 Power BI的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！