Forum Discussion

dkehoe32's avatar
dkehoe32
Icon for Helper I rankHelper I
8 years ago

trying to make a table

Im essentially trying to recreate this colored table in BI.  I have all the data in BI but i have no idea how to create the data into a pivot table which would give me the values for the table.
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Is this in Excel or Power BI Desktop? In Desktop, you would use a matrix visualization and then you would need to use Conditional Formatting most likely.

  • dkehoe32's avatar
    dkehoe32
    Icon for Helper I rankHelper I
    8 years ago

    The picture is from excel and i want to recreate it in BI

    • Shantanu00007's avatar
      Shantanu00007
      Icon for Helper I rankHelper I
      8 years ago
      You need to create 3 seperate tables and align them in such a way that it looks like a table. I guess this is the only workaround in powerbi.
      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi

         

        With Measures, you can do this in Matrix visual, for background colouring, you need to use conditional formatting.

         

        If you need more details, you need to share how your source data looks like.

         

        Thanks

        Raj