Forum Discussion

vinoothna9's avatar
vinoothna9
Frequent Visitor
5 years ago
Solved

Excel to Power BI

  I have a summary page(Table) in Excel which I have to replicate in Power BI. The table has three columns 1. first column is all categories. 2. second column has pipeline amount for each category...
Need Help
Tips and Tricks
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, vinoothna9 

    According to your expected result, I think you can achieve this in Power BI through Matrix

    I created the test data like this:

     

    Then I created a Matrix and place columns like this, and set the value type to “sum”:

     

    And I guess this is what you want.

    You can download my test pbix file here

    More info about Matrix in Power BI

     

    If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

    How to Get Your Question Answered Quickly 

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

vinoothna9's avatar
vinoothna9
Frequent Visitor
5 years ago

1. Cat 2 - Amount received is a calculated value with certain filters

 

2. Cat 3 - Amount received is also a calculated value with different filter.

 

* Each value in the cells are caluculated values with different filters.

 

 I understand we can achieve this view/Table in Excel. How can I replicate the same visual in Power BI ?