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.

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
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.