Forum Discussion

kevinsmith27's avatar
kevinsmith27
New Member
8 years ago
Solved

Power BI Matrix Column Assistance

Hello Community,   Can I kindly request assistance with the following matrix column issue:   Reffering to the PRIORITY column, I need to simulate the following results from Excel in Power BI:   ...
  • kevinsmith27's avatar
    kevinsmith27
    New Member
    8 years ago

    Hi v-jiascu-msft,

     

    Thank you very much for the reply, your demo really helps.

     

    Could I kindly request assistance on how to achieve what you did in your demo with my original dataset.  All my data is part of one Excel table as below (Required fields highlighted):

     

    Currently my Matrix Table looks as below:

     

     

     

    I need to find a way to insert the priorities column as per the example in your demo, but I am usure how to do this without dimensional tables, all my data is part of a single Excel table.  How do I achieve this?

     

    Example data as below:

     

    Thank you for the help!

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi kevinsmith27,

       

      If we don't have dimensional tables, some values could be missing. Please refer to the snapshot below. 

      1. Extend to the next level.

      2. Don't establish a relationship with other tables through Date column. Then we can use the date hierarchy.

      Power_BI_Matrix_Column_Assistance2

       

      Best Regards,

      Dale