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
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