Forum Discussion

kaye123's avatar
kaye123
Frequent Visitor
3 years ago

Creating Visual Table w/ Calculated Measure from Multiple Query

Hi. I created several Calcultaed measure on different Table query. Now, I need to create a summary table which will provide me different numbers per cell as below. Each cell in Yield and Cost column ...
Need Help
Umair_Aslam's avatar
Umair_Aslam
Helper I
3 years ago

Hi kaye123 

you can use cards for it and set them in a tabular form.

every card has shown different measure values and fixed them as a table.

Like.

 

 

  • kaye123's avatar
    kaye123
    Frequent Visitor
    3 years ago

    Thanks for this. I have tried this. I am planning to setup multiple columns (around 30columns), replicating what i did in excel macro.  Cards will might be crowded with this setup. Are there any options?

     

     

    • Umair_Aslam's avatar
      Umair_Aslam
      Helper I
      3 years ago

      Hi kaye123 
      I had the same requirement and I handled that by using the card, but if you don't want to use the card try matrix visual. 
      Note: Power BI might be different from excel, what did you do in excel sometimes it can't be implemented in Power bi.
      That's why I prefer cards for this requirement and clients accept that.